Ranking based on values

**bpctrader** · 02-05-2012, 03:55 PM

Hi,

I'm trying to rank a set of individuals based on scores. Specifically, I'm want to find the top three each day. In the attached example, cell B2 would return "D*ck" since he had the highest score that day (cell A2). Cell C2 would return "Sally" since she had the second highest score and cell D2 would return "Jennifer" since she had the third highest score. My goal is to do this for everyday in the time series.

Can anyone help me out with a function that can accomplish this?

Thank you very much for your help.

**Haseeb Avarakkan** · 02-05-2012, 04:14 PM

Hi, try this,

B2, copy across & down.

=INDEX($F$1:$M$1,MATCH(1,INDEX(($F2:$M2=LARGE($F2:$M2,B$1))*ISNA(MATCH($F$1:$M$1,$A2:A2,0)),0),0))

**bpctrader** · 02-05-2012, 05:29 PM

Thanks for the response. However, when I copy this into the relevant cells, I get a "#N/A" error. Any thoughts?

**Haseeb Avarakkan** · 02-05-2012, 05:37 PM

See the attached.

**bpctrader** · 02-05-2012, 05:45 PM

I found the error! You are the best. Many thanks.

**Haseeb Avarakkan** · 02-05-2012, 05:49 PM

Glad it works

If you are satisfied with solution please mark the thread as SOLVED.

- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save