MINVISIBLEA

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

rgeValues

REMARKS
* This function excludes hidden cells caused by AutoFilter, Grouping or that have been Manually Hidden.
* You can use the built-in MINA function to include hidden cells.
* You can use the add-in MINVISIBLE function to
* You can use the add-in MINVISIBLEIFS function to
* You can use the user defined AVERAGEVISIBLEA function to
* You can use the user defined COUNTVISIBLEA function to
* You can use the user defined MAXVISIBLEA function to



For instructions on how to add this function to a workbook refer to the page under Inserting Functions


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