MINAVISIBLE

Returns the smallest value from the visible, non blank cells (including logical values and text).

Remarks

* This function excludes hidden cells.
* You can use the MINA function to include hidden cells.
* For instructions on how to add a function to a workbook refer to the page under Inserting Functions