Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Name | Number | Rank | 2 | |||
2 | Name 1 | 12 | 7 | Name 3 | |||
3 | Name 2 | 15 | 1 | Name 8 | |||
4 | Name 3 | 14 | 2 | Name 9 | |||
5 | Name 4 | 10 | 9 | #NUM! | |||
6 | Name 5 | 11 | 8 | ||||
7 | Name 6 | 13 | 5 | ||||
8 | Name 7 | 13 | 5 | ||||
9 | Name 8 | 14 | 2 | ||||
10 | Name 9 | 14 | 2 | ||||
Sheet4 |
Hey I need a formula for the 2nd highest number from a column and 3rd highest number from a column and then when i get that number that it displays the name of the person who is listed in a different column..
Thanks
aaTop 3 FormulaApproach 81shelly.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Name | Score | Top | Name | Score | Sum of Score | ||||||
2 | Karl | 24 | 3 | 4 | Diana | 52 | Name | Total | ||||
3 | Dan | 45 | Dan | 45 | Diana | 52 | ||||||
4 | Diana | 52 | Cem | 32 | Dan | 45 | ||||||
5 | Cem | 32 | Brian | 32 | Brian | 32 | ||||||
6 | Brian | 32 | Cem | 32 | ||||||||
7 | Daphne | 28 | Grand Total | 161 | ||||||||
8 | Jan | 26 | ||||||||||
9 | Carla | 30 | ||||||||||
10 | ||||||||||||
11 | ||||||||||||
Sheet1 |