Hi! I have a report and I would like to get the maximum frequency in 9 weeks rolling period. here's my initial formula, but i need to change the range everytime i update the report.. Any help would be appreciated
IF(MAX(FREQUENCY(IF(AO9:AW9<>"",COLUMN(AO9:AW9)),IF(AO9:AW9="",COLUMN(AO9:AW9))))>1,MAX(FREQUENCY(IF(AO9:AW9<>"",COLUMN(AO9:AW9)),IF(AO9:AW9="",COLUMN(AO9:AW9))))&"weeks consecutive","")
How does your range extend...by adding rows or by filling more cells to the right?
Assuming you have up to 52 weekly values in AO9:CN9
This ARRAY FORMULA, completed by holding down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER) returns the max consecutive values in the 9 cells ending with the last numeric value cell in AO9:CN9
Formula:
Please Login or Register to view this content.
Is that something you can work with?
Works like a charm..Very impressive! Thanks for your help Ron! Appreciate it very much..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks