# Get maximum frequency in 9 weeks rolling period

1. ## Get maximum frequency in 9 weeks rolling period

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","")

2. ## Re: Get maximum frequency in 9 weeks rolling period

How does your range extend...by adding rows or by filling more cells to the right?

3. ## Re: Get maximum frequency in 9 weeks rolling period

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?

4. ## Re: Get maximum frequency in 9 weeks rolling period

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

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1