Pull Top Three Values in List Only If in Specific Year

1. Pull Top Three Values in List Only If in Specific Year

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.

2. Re: Pull Top Three Values in List Only If in Specific Year

E5:
``Please Login or Register  to view this content.``
f5:
``Please Login or Register  to view this content.``

3. Re: Pull Top Three Values in List Only If in Specific Year

With a pivot table.

See column J and K.

4. Re: Pull Top Three Values in List Only If in Specific Year

Formula:
`Please Login or Register  to view this content.`

Copy to D12

Change number in Blue for another top rank.

6. Re: Pull Top Three Values in List Only If in Specific Year

@ashakantasharma

It is common use, you also add the solution, or even better the formula, in the text of the reply.

In that cases forummembers don't have to open you excel file, to see what solution is been offered.

See e.g. #4 of Bo_Ry

That is also usefull, if a member can't open the excel file (like me in this case).

7. Re: Pull Top Three Values in List Only If in Specific Year

Thanks for the rep.

If you are satisfied with the solution, please mark the question solved.

There are currently 1 users browsing this thread. (0 members and 1 guests)