Hello everyone
I'm trying to use the formula =MAX(FREQUENCY(IF(T2:T11>1,COLUMN(T2:T11)),IF(T2:T11>=1,COLUMN(T2:T11)))) to find more than one maximum value before a zero from a range.
Column T has this values
I want a formula/formulas that will return 2 and 6
Thank you
I'm trying to use the formula =MAX(FREQUENCY(IF(T2:T11>1,COLUMN(T2:T11)),IF(T2:T11>=1,COLUMN(T2:T11)))) to find more than one maximum value before a zero from a range.
Column T has this values
1 |
2 |
0 |
1 |
2 |
3 |
4 |
5 |
6 |
0 |
I want a formula/formulas that will return 2 and 6
Thank you