| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look for similar text and find the largest value and return value
Hello,
What is the formula to look for similar word under KEY and get it to look for the highest value and REV and retun the RESULT value? Example below KEY REV RESULT a 0 1 b 0 5 c 0 2 b 1 6 c 1 3 b 2 4 want result to be... a 0 1 b 2 4 c 1 3 |
Threaded Mode
