Hi
I have a sheet where column a contains a code, another sheets column p contains the age of the member. There can be 6 members under the code
Now i want to have a array formula in vba to find the max value in column p for code equal to code in sheet a.
sheet a
col a col b
111
112
and so on
sheet 2
col a col b col c
111 1 58
111 2 56
112 1 60
112 2 55
112 3 25
112 4 23
and so on
Can anybody help
I have a sheet where column a contains a code, another sheets column p contains the age of the member. There can be 6 members under the code
Now i want to have a array formula in vba to find the max value in column p for code equal to code in sheet a.
sheet a
col a col b
111
112
and so on
sheet 2
col a col b col c
111 1 58
111 2 56
112 1 60
112 2 55
112 3 25
112 4 23
and so on
Can anybody help