VBA in Excel: How to keep relevant rows only?
 

Hi everybody!

Do you know, guys, about some easy way how to tell VBA in Excel to g
thourgh all cells in worksheet and keep those ones with highest numbe
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 lis
above this selection below?

value1 7
value2 5
value3 5
value4 6

Any ideas, please feel free to post!

Regards,
Joh

--
jl8
-----------------------------------------------------------------------
jl88's Profile: http://www.excelforum.com/member.php...fo&userid=1487
View this thread: http://www.excelforum.com/showthread.php?threadid=26499