SanFelippo
Board Regular
- Joined
- Apr 4, 2017
- Messages
- 124
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?
<colgroup><col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" span="13">
<tbody>
</tbody>
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 |