ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to copy top 3 value in column (https://www.excelbanter.com/excel-programming/447338-macro-copy-top-3-value-column.html)

ixara

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


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com