Hi Shu, you need the extra brackets for multiple ranges:

=SMALL((E6:F11,D18),COUNT(E6:F11,D18)-RANK(AC60,(E6:F11,D18))+2)

but my preference is to use a named range instead. (You can do this by
selecting the range and typing "Array" in the Name Box which is just to the
left of the Formula Bar)

"Shu of AZ" wrote:

=SMALL(E6:F11,D18,COUNT(E6:F11,D18)-RANK(AC60,E6:F11,D18)+2) results in a
too many arguments ( this is the correct array Im using )

Placed in AD60

"Lori" wrote:

I think you may be able to simplify things a little.
Assuming "Array" is (E60:F10,G22), enter:

AC60: =MIN(Array)
AD60: =SMALL(Array,COUNT(Array)-RANK(AC60,Array)+2)

(or whatever your range to fill is) and fill right for the unique values.
["Array" could also refer to multiple sheets e.g. Sheet1:Sheet3!E:G]