Example: https://docs.google.com/spreadsheets/d/1vE5DSC5bQMuHGMk3IRtLqFpTlr6AsfFvk0hMYZLts7o/edit?usp=sharing
Let's say I have the following table
Table 1 is titled "Scoring"
Tom | Mike | Carl | |
---|---|---|---|
G1 | 4 | 1 | 5 |
G2 | 5 | 2 | 7 |
Total | 9 | 3 | 12 |
I know I can use functions to determine what number is the largest (First place), second largest (Second Place) and third-largest (third place) number is...
=LARGE(B4:D4, 1)
=LARGE(B4:D4, 2)
=LARGE(B4:D4, 3)
And that will return 12
9
and 3
respectively. Is it possible to take those numbers, and get the name (from row 1) that corresponds to them? So my output would be Carl
Tom
and Mike
in that order. If needed, two steps can be made (So step one is to get the number, and step two (In a different cell) is to find the name.
Here is what I want the final output to look like:
Tom | Mike | Carl | |||
---|---|---|---|---|---|
G1 | 4 | 1 | 5 | 1st | Carl |
G2 | 5 | 2 | 7 | 2nd | Mike |
Total | 9 | 3 | 12 | 3rd | Tom |
I guess I should mention that the names are stated externally, and are shown in the table above using =Info!B[number]
and the totals are calculated from adding the G1 and G2 scores together.
Carl
Mike
andTom
in that order." But as I see it, 12, 9, 3 corresponds to the names in order ofCarl
Tom
Mike
instead. Also, it is unclear where you would like the output. It would help move things along if you shared a link to a sample spreadsheet containing the posted data and clearly indicating where the results should go, as it will save the volunteers making their own spreadsheet first.