Thread: help with SMALL based on criteria

hi,

I have 2 columns and need to find, of all items in Item that are "B", the 2nd smallest number in Number.

Item Number
A 7
B 5
B 4
B 2
C 1
A 2
C 6
B 13

should return 4

Thanks.

Hello, Try

Assume your data is in A1:B9 including header.

=SMALL(IF(A2:A9="B",B2:B9),2)

This is an Array Formula, must hit CONTROL+SHIFT+ENTER, rather than just ENTER