Forum Discussion
Problem with named Range
Hello, i used followed formula without problems: =MIN(IF($B$2:$B$266<>0;$B$2:$B$266)) also worked: =MIN(IF(NamedArea<>0;NamedArea)) (where NamedArea=$B$2:$B$266) but when i Named the same Range on...
MIN-IF won't calculate noncontiguous ranges even if the criteria and value ranges are both named items (and both noncontiguous).
The best approach may be to use the entire range but use FILTER to exclude the rows you don't want to include and then find the MIN.
Hello, thank you also for your explanation. That just confirmed my suspicion. The tip with the filter was very good. Thanks for that too.
greeting
greeting