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...
Like this: =MIN(FILTER(B2:B266,(MOD(ROW(B2:B266),2)=0)*(B2:B266<>0)))
Thanks so much, that is a great solution! It works very fine.
How can i use it with the function IFS?
It´s the same Problem, i need only every second Cell.
my formula works but is very long for 69 rows.
It looks like this:
=IFS(G98=G259;B98;G100=G259;B100; ... G234=G259;B234)
How can i Use FILTER with IFS?
All my tries are false 😞
- The formula only looks at alternate rows. It does this by only looking at rows where the row number is divisible by two, with a remainder of zero.
MOD(ROW(B2:B266),2)=0