VBA in Excel: How to keep relevant rows only?

J

jl88

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue with conditional formatting - Formula changing 1
VBA: Insert rows 1
PROBLEM: Formula Changes in conditional format 0
how to transpose a table into two columns? 1
Index match with multiple criteria(different than usual) 3
how to compare/sort values in two columns of two worksheets? 4
Paste formula in a specified number of columns to the right 0
Copy paste from one worksheet to other. 2

Top