Find the Max value...

[Viki Sharma]

Dear Friends,
Expecting some excel help from you.
I have some data in two columns just like what I mention below;

column A column B
C08465446 2
C08465446 6
C08465446 5
C09543553 14
C09543553 7
C09543553 9

Now, what I really want to find out the max values of column B with reference of column A.

For Exp.

column A column B
C08465446 6
C09543553 14

Thanks in advance.
Regards,
Viki

 

[Mike H..]

Dear Friends,
Expecting some excel help from you.
I have some data in two columns just like what I mention below;

column A column B
C08465446 2
C08465446 6
C08465446 5
C09543553 14
C09543553 7
C09543553 9

Now, what I really want to find out the max values of column B with reference of column A.

For Exp.

column A column B
C08465446 6
C09543553 14

Thanks in advance.
Regards,
Viki

Hi,

Try this array formula, see below for how to enter it.


=MAX(IF(A1:A20="C08465446",B1:B20))

Of course it's much better to have the lookup value in a cell like this where
C1= C08465446
or

C1=C09543553

=MAX(IF(A1:A20=C1,B1:B20))


This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter. If you do it correctly then Excel will put curly brackets
around the formula {}. You can't type these yourself. If you edit the formula
you must enter it again with CTRL+Shift+Enter.