calculate max age

[prlondhe]

CLIENT CODE	SUB CODE	COMPANY	POLICY TYPE	POLCY SUB TYPE	VEHICLE NUMBER	SERIAL NUMBER	INSURED NAME	BIRTH DATE	SUM INSURED	AGE	max age
X104	5	NIA	MEDICLAIM	INDIVIDUAL	1	xyz	21/10/1957	200,000	59
X104	5	NIA	MEDICLAIM	INDIVIDUAL	2	abc	07/08/1959	200,000	57

<colgroup><col span="7"><col><col><col><col><col></colgroup><tbody>
</tbody>

Hi

I have the above file which contains age for each individual.
there can many records with client code.
Now I want to calculate the max age for each client code in column a with vba. Can somebody help

 

[jeffreybrown]

Maybe you could tell us how you get the max age?

EDIT: Must have missed the client code part

 

[pjmorris]

Try this in cell L1:

=MAX(IF($A$2:$A$4="X104",$K$2:$K$4)) and enter with CTRL-SHFT-ENTER to make it appear like this: {=MAX(IF($A$2:$A$4="X104",$K$2:$K$4))}

Then copy down.

You'll obviously need to adjust the ranges as necessary before copying.