I have data of parts (col a) and qty (col b) and I'd like to return a list
(other place on the worksheet) to show what parts have the min all the way to
the max. I'm using SMALL to return the part quantity, but I cannot figure
how to get the part ID next to the qty.
I have
Part A 2
Part B 0
Part C 0
Part D 2
Part E 3

I cannot sort this part of the spreadsheet, but I use Small and get
0
0
2
2
3

I'd like to get
0 Part B
0 Part C
2 Part A
2 Part D
3 Part E


--
Thanx