LinkBack URL
About LinkBacks
fINALLY...
=INDEX($B$2:$J$2,MATCH(MAX(($B$1:$J$1=$A3)*IF($B$2:$J$2="A",1,IF($B$2:$J$2="B",2,$B$2:$J$2))),IF($B$2:$J$2="A",1,IF($B$2:$J$2="B",2,$B$2:$J$2)),0))
array entered.
fINALLY...
=INDEX($B$2:$J$2,MATCH(MAX(($B$1:$J$1=$A3)*IF($B$2:$J$2="A",1,IF($B$2:$J$2="B",2,$B$2:$J$2))),IF($B$2:$J$2="A",1,IF($B$2:$J$2="B",2,$B$2:$J$2)),0))
array entered.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks