Look for similar text and find the largest value and return va
Ok.....
with this data in A2:C7 -
a 0 1
b 0 5
c 0 2
b 1 6
c 1 3
b 2 4
A10 = A
A11 = B
A12 = C
Enter this formula in B10 using the key combination of CTRL,SHIFT,ENTER (not
just ENTER):
=MAX(IF(A$2:A$7=A10,B$2:B$7))
Enter this formula in C10 using the key combination of CTRL,SHIFT,ENTER (not
just ENTER):
=INDEX(C$2:C$7,MATCH(1,(A$2:A$7=A10)*(B$2:B$7=B10) ,0))
Select both B10 and C10 and copy down to row 12.
Results will be:
A 0 1
B 2 4
C 1 3
Biff
"Quan" wrote in message
...
In this example, 3 columns with headings: Key, Rev, and Result.
I my worksheet it will have 15 columns.
"Biff" wrote:
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
|