MINVISIBLEIFS
Returns the smallest value from the visible, non blank cells that satisfies multiple conditions.
min_range | The actual cells to min |
criteria_range1 | The range of cells you want evaluated. |
criteria1 | The 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
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext