Hi!

How many columns is this data in?

a 0 1
b 0 5
c 0 2
b 1 6
c 1 3
b 2 4

Biff

"Quan" wrote in message
...
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