| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find max # and display name
My setup and my issue:
I have Name1 in cell B2 and their score in cell C2. I have Name2 in cell F2 and their score in G2. What I am trying to do is compare the two scores, and then display the name of whoever is higher. I think I am close with the formula =INDEX((B2,F2),MATCH(MAX(C2,G2), (C2,G2))) but I am not getting a result. Any help is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value every time it appears and display cell above | Excel Worksheet Functions | |||
| HOW? Find and display the last cell in a column with a value 0 | Excel Discussion (Misc queries) | |||
| Find date query and Display issue | Excel Worksheet Functions | |||
| trying to find how to display worksheet name in cell | Excel Discussion (Misc queries) | |||
| can excel find the last used line in a column and display it? | Excel Worksheet Functions | |||
Threaded Mode
