This is a continuation of my previous thread:
http://www.excelforum.com/excel-work...-criteria.html
I now need to get the top 3 max and the top 3 min qty in column c and return the part number from column A instead of the qty. Is there a function/way to do it?
I don't know if I still need to attach my sample sheet, the attachment is at the link above. Just inform me if you need a sample workbook.
Thanks a million! Excel Forum really helped a lot(and of course the other forums too).
Bookmarks