Hi,

I have the following data in a list:

Col A Col B Col C Col D
B 9 1 Red
C 12 3 Green
A 13 1 Red
B 14 2 Violet
C 15 4 Yellow
B 16 2 Yellow
A 18 2 Green
B 19 2 Green
C 21 5 Red


I want to retain only those rows whe
1. For each unique value in Column A, the value in Column B is maximum
and Column C in that row has the sum of col c for that unique value.
The output from the above list should be:

Col A Col B Col C Col D
A 18 3 Green
B 19 11 Green
C 21 8 Red


Thanks in advance for all the help.

Regards,
Raj