MAXVISIBLE

MAXVISIBLE(unit)
Returns

unitThe unit

REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the built-in MAX function to include hidden cells.
* This is similar to the AVERAGEVISIBLE, COUNTVISIBLE, MINVISIBLE and SUMVISIBLE functions.
Columns=1

 A
1??


© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext