Hi, and welcome to the forum.
First use a helper column E and enter the formula:
in E4 and copy down![]()
=MAX(B4:D4)
Now in A12 enter the formula:
and copy down.![]()
=INDEX($A$1:$A$9,MATCH(B12,E:E,FALSE),1)
HTH
Hi, and welcome to the forum.
First use a helper column E and enter the formula:
in E4 and copy down![]()
=MAX(B4:D4)
Now in A12 enter the formula:
and copy down.![]()
=INDEX($A$1:$A$9,MATCH(B12,E:E,FALSE),1)
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks