MAXAVISIBLE

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

Remarks

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