[SOLVED] Find a winner

**MADx** · 10-18-2008, 07:08 PM

I have a chart that we update each day the layout starts on the left.

name ranking total days of the week(this is were we input #'s)

on another area on the page I want to list the names in order of their ranking. I need to find the person ranking #1 (column B) and return the name next to it in (column A) then in the next cell under do the same for the 2nd persons name.

**martindwilson** · 10-18-2008, 08:28 PM

please post an example workbook

**MADx** · 10-18-2008, 09:03 PM

I input numbers in column e-k the total of them is in column c and then column b ranks the employees. Once i have them ranked I want to put the names in order of ranking in f23-j36

**snasui** · 10-18-2008, 09:48 PM

Try this,

F23

Please Login or Register  to view this content.

Copy to I23 and copy both down.

Hope this helps.

**MADx** · 10-18-2008, 09:54 PM

you are amazing thank you

**ratcat** · 10-18-2008, 09:58 PM

G'day

I may have taken the scenic route of getting the final answer, but its the only way that I know too get a unique winner across the whole week if the score were tied. The one with the highest scores during the week win if the score are tied.

See attachment