Help with getting Top 3 Advisors

[scottydoouk]

Hi Guys,

I sadly cant share the sheet as it is confidential. I have tried ChatGPT to help me and I just can't figure out what is wrong. So I have a sheet called WeeklyRaw which has all my teams weekly performance data. This is setup in a table configuration called WeeklyProcessing. What I need is a formula that will look at the last 3 months from todays date using the week commencing column, average each advisors Average Handling Time and show me the lowest 3 in another sheet called Weekly Dashboard in Cells M3, M4, M5 and their Average AHT in N3, N4, N5. I want it to dynamically update when I have included new weekly raw data too. Is this easily done?

This is one of the formulas that ChatGPT told me would work, but I kept getting "too few arguments" error:

=INDEX(WeeklyAHTPivot!$B$4:$B$200,MATCH(SMALL(IFERROR((AVERAGEIFS(WeeklyAHTPivot!$F$4:$F$200,WeeklyAHTPivot!$A$4:$A$200,">="&TODAY()-90,WeeklyAHTPivot!$A$4:$A$200,"<="&TODAY()))),""),ROW(M3:M5)),0))

Hoping you can help

 

[awoohaw]

While it is recognized that anonymity is critical, you can still create dummy data and worksheets to post using the xl2bb add in. The link is below.
please help the forum help you!

 

[Peter_SSs]

As well as some (fairly small) dummy sample data and expected results with XL2BB, what should happen if 2 (or more) advisors are equal 3rd lowest?

BTW, I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)