Formula to get name of top scorers

I have the following Data Set:

Name Score

Bob 0

Sally 0

Mary 3

James 12

Matt 0

Pat 32

Sanjay 1

Vincent 22

Scott 12

Srikanth 0

Deb 16

Wynton 0

I am using a formula like this:

=LARGE([Score]$1:[Score]$12 1)

to find the value of the highest score

=LARGE([Score]$1:[Score]$12 2)

to find the second highest

=LARGE([Score]$1:[Score]$12, 3)

to find the third highest. populate three cells like below




That all works great. What I'd like to do now is populate the column prior to the 32, 22, and 16 values with the name on the row where that value was found.

so for 32 the name is Pat, for 22 it is Vincent, for 16 it is Deb.

so the resulting two columns and 3 rows would look like this.

Pat. 32

Vincent 22

Deb. 16

I've tried variations on this formula below with now success.

=LOOKUP("LARGE([Score]1:[Score]12, 1)", [Name]1:[Score]12, 1)

Any Suggestions?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!