Show value of row 1, where row 2 is greatest
Solved/Closed
Related:
- Show value of row 1, where row 2 is greatest
- 텐타클 락커 2 - Download - Adult games
- Saints row 2 cheats - Guide
- Tentacle locker 1 - Download - Adult games
- Fnaf 1 download pc - Download - Horror
- Call of duty modern warfare 2 2022 free download - Download - Shooters
2 responses
aquarelle
Posts
7180
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Feb 2, 2012 at 04:10 PM
Feb 2, 2012 at 04:10 PM
Hi,
Try and adapt this formula :
Regards
Try and adapt this formula :
0 1 2 3 4 5 6 7 8 9 10 0 2 5 6 5 1 3 1 0 0 0 =INDEX($A$1:$K$1,1,MATCH(LARGE(A2:K2,1),A2:K2,0)) 1 4 2 4 5 4 2 1 0 0 0 =INDEX($A$1:$K$1,1,MATCH(LARGE(A3:K3,1),A3:K3,0)) 0 4 6 5 1 5 0 1 0 0 1 =INDEX($A$1:$K$1,1,MATCH(LARGE(A4:K4,1),A4:K4,0)) 1 0 5 8 5 3 1 0 0 0 0 =INDEX($A$1:$K$1,1,MATCH(LARGE(A5:K5,1),A5:K5,0))
Regards