Ranking Formula

[SanFelippo]

Hello,

I have a list of Data with the following headers: Count, Year, ID.

What I am trying to do is come up with a formula that will give me the top 25 IDs for each year that have the highest counts. Basically the table I want to fill out looks like what you see below. I need a formula that will find and return the ID of each rank for each year. Any ideas?

		Year
		2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017
Rank	1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

<colgroup><col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" span="13"> <tbody> </tbody>

 

[Eric W]

Glad we could help.

Come back if you have followup questions.