=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]