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

Use AutoFilter and sort the data by Column B, in ascending order.
Alternatively, by formula, assuming that A2:B6 contains the data, try...

E2, copied down:

=SMALL($B$2:$B$6,ROWS(E$2:E2))

F2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=INDEX($A$2:$A$6,SMALL(IF($B$2:$B$6=E2,ROW($A$2:$A $6)-ROW($A$2)+1),COUNTI
F($E$2:E2,E2)))

Hope this helps!

In article ,
BCNU wrote:

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