![]() |
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