I am trying to automatically pull in the top three values per year.
Based on the number of webinar registrations, pull in the top 3 webinars -> title and number of registrations.
I've included a small sample set. This gets updated daily with multiple new events, and this will allow us to in. real time see the top 3 events.
The formula I am currently using is:
Rank 1: =INDEX(A17:A300,MATCH(LARGE(E17:E300,1),E17:E300,0))
Rank 2: =INDEX(A17:A300,MATCH(LARGE(E17:E300,2),E17:E300,0))
Rank 3: =INDEX(A17:A300,MATCH(LARGE(E17:E300,3),E17:E300,0))
This works to pull in the top three overall, but it doesn't work to pull in only 2019, or only 2020.
It is the text in red I am trying to write formulas for, based on the data set below the red text.
Bookmarks