| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel cash book: formula to duplicate amt in relevant exp column | Excel Worksheet Functions | |||
| Concatenating Relevant Headings | Excel Discussion (Misc queries) | |||
| Excel value and the relevant text column | Excel Worksheet Functions | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| about accounting book relevant to excel | New Users to Excel | |||
Threaded Mode
