MAXVISIBLE

Returns the largest value from the visible, non blank cells.

Remarks

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