MAXVISIBLE
MAXVISIBLE(rgeValues)
Returns the largest value from the visible, non blank cells.
| rgeValues | The cells to max. |
| bIncludeText | Whether to include text. |
| bIncludeErrors | Whether to include error values. |
REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* The built-in MAX function will always include hidden cells.
* You can use the add-in MAXIFSVISIBLE function to return the largest value from the visible, non blank cells that satisfies multiple conditions.
* Similar to the AVERAGEVISIBLE, COUNTVISIBLE, MINVISIBLE and SUMVISIBLE add-in functions.
 |
MORE FUNCTIONS
??
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext