CreativeRova
New Member
- Joined
- Dec 12, 2013
- Messages
- 49
Hi,
i have a table that i want to extract from. 1st 2nd 3rd etc
eg
<tbody>
</tbody>
See above. in B5 i want it to automatically choose the highest average team and display the team name.
i.e - First will be Giants as their average is highest.
I know the formula to sort hjighest is large(b2:b5,1) and so on but that return the average not the team name how do i use the offset formula with LARGE to return the name?
i have a table that i want to extract from. 1st 2nd 3rd etc
eg
team | average | position | TEAM | |
GIANTS | 1.000 | FIRST | ||
TWINS | 0.000 | SECOND | ||
RED SOX | 0.750 | THIRD | ||
METS | 0.500 | FOURTH | ||
<tbody>
</tbody>
See above. in B5 i want it to automatically choose the highest average team and display the team name.
i.e - First will be Giants as their average is highest.
I know the formula to sort hjighest is large(b2:b5,1) and so on but that return the average not the team name how do i use the offset formula with LARGE to return the name?