Hi,
I have 6 columns in the sheet1.
The column A has the address and column E has numbers.
The first, I have to find the duplicate addressees in column A.
The second, in the duplicates I have to compare numbers in column E.
If a row that the number is the biggest will be left and other duplicates will be removed.

For example,
A B C D E F
123 Abc St. 3
123 Abc St. 45
123 Abc St. 100
2244 Qwe Dr. 90

In the above example, I have to leave the third row '123 Abc St.', because the addresses in three rows are the same,but the number in column E, 100 is the bigger than others.


So the result will be like below;

A B C D E F
123 Abc St. 100
2244 Qwe Dr. 90

How can I do this?
Thanks in advance.