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...
As you have established, Excel will not accept a multi-area range as an argument of an inequality, though some aggregation operators work. If you turn the values from the alternate cells into an array then normal rules prevail. For example
= LET(
index, SEQUENCE(ROWS(range)/2,1,1,2),
alternateValues, CHOOSEROWS(range,index),
MIN(IF(alternateValues<>0, alternateValues))
)
works perfectly well.