MINVISIBLEIFS

Returns the smallest value from the visible, non blank cells that satisfies multiple conditions.

min_rangeThe actual cells to min
criteria_range1The range of cells you want evaluated.
criteria1The expression that contains the criteria.
criteria_range2(Optional) The range of cells you want evaluated.
criteria2(Optional) The expression that contains the criteria.

Remarks

* This function excludes hidden cells.
* There is no MINVISIBLE function because this function can be used with one argument.
* You can use the MINIFS function to include hidden cells.
* The equivalent VBA function is MINVISIBLEIFS

 A
1??



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