Thread: Look for similar text and find the largest value and return value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Quan Quan is offline
external usenet poster
  
Posts: 3
Default 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

Reply With QuoteReply With Quote