I want to ask a question... is about ms excel... i have 2 field, an i want to find the greatest number in the second field with a condition must match a value in field 1

Question

anonymous · Answer

field 1      field 2
a              1
b              1
c              1
a              2
a              3
b              2

i want to find the greatest number in field 2 which it's field 1 is "a"

anonymous · Answer

what fomula should i use?? (VBA is not allow)

anonymous · Answer

the attached Word document shows how I got the answer.

anonymous · Answer

your doc is good, but i have find a more batter way to solve already. use 

MAX(IF(A2:A7="a",B2:B7))

Than press 

ctrl + shift +enter 

to insert the formula