I
ixara
Dear all,
I've columnA(code), columnB(desc) and columnC(value) in sheet1. How ca
i copy top 3 highest value for each desc into sheet2?..Below is th
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 87
I've columnA(code), columnB(desc) and columnC(value) in sheet1. How ca
i copy top 3 highest value for each desc into sheet2?..Below is th
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 87