I have excel with 3 column. I have to check second column value if they are repeating. If they are repeating, we should check the 3rd column which consists of integers. If two of the 2nd column cells are repeating, we should check the 3rd column cells for the values and compare the two values and take which one is maximum.and delete the other dupilcate.
Column1 column2 column3
Arun 25d 10
Bala 25d 20
In the above case, 1st to be deleted and I have the name bala as result .
Here column 2 is same, max of column 3 should be taken.
Thanks in advance