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