| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro to copy top 3 value in column
Dear all,
I've columnA(code), columnB(desc) and columnC(value) in sheet1. How can i copy top 3 highest value for each desc into sheet2?..Below is the illustration of the scenario. Thanks in advance for any help. Sheet1 ColumnA ColumnB ColumnC abc123 item1 5987 def312 item1 2324 ert343 item1 424 pty325 item1 342 ade234 item2 1234 ert355 item2 987 rey299 item2 873 trey244 item2 444 retrt345 item2 434 sheet2 ColumnA ColumnB ColumnC abc123 item1 5987 def312 item1 2324 ert343 item1 424 ade234 item2 1234 ert355 item2 987 rey299 item2 873 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel macro to copy the rightmost column to a new column | Excel Discussion (Misc queries) | |||
| Modify a Macro - Copy Tab Name and Add To Column A | Excel Programming | |||
| macro to copy following cells in the same column | Excel Discussion (Misc queries) | |||
| Copy 3 columns become one column with macro | Excel Programming | |||
| Copy time from one column to another in a macro | Excel Programming | |||
Threaded Mode
