I have duplicate entries in excel want to filter them keeping the highest value matching second column. For example Column 1 Column 2 123456789 2 123456889 3 You can see here column 1 has duplicate entries but I want to keep the one which has value 3 in column 2 There are thousands such entries I like to do it in excel for mac if you think you can not only provide me solution rather guide me through the formula that would be great