Hi everybody!

Do you know, guys, about some easy way how to tell VBA in Excel to go thourgh all cells in worksheet and keep those ones with highest number of each 'value' in list similar to the following?

value1 6
value1 3
value1 5
value1 7
value2 5
value2 3
value3 5
value4 2
value4 6

Basically, is it possible to get via some universal VBA from the list above this selection below?

value1 7
value2 5
value3 5
value4 6

Any ideas, please feel free to post!

Regards,
John