Hi guys!
I'm working on an excel formula that counts the number of consecutive months with values between 1 and 5.
I've created a few other formulas successfully with different criteria but i'm tied up with the range portion.
- Consecutive Months with values equal to 1
- MAX(FREQUENCY(IF(C2:N2=1, COLUMN(C2:N2)), IF(C2:N2<>1, COLUMN(C2:N2))))
- Consecutive Months with values greater than 5
- MAX(FREQUENCY(IF(C2:N2>=5, COLUMN(C2:N2)), IF(C2:N2<5, COLUMN(C2:N2))))
Does anyone have any recommendations or tips in accomplishing this?
Thanks for your help!
Bookmarks