3 largest qty and 3 smallest

[geng]

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).