If you download and install the morefunc.xll add-in (try google to
locate)...

=SMALL(ARRAY.JOIN(A3,C5,D18,Sheet2!A2,Sheet3!A1), 2)


Chickalett wrote:
Wrote:

=SMALL((A3,C5,D18,D21), 2)

Thanks,
What if my values are on different sheets, like for instance:
=SMALL((A3,C5,D18,Sheet2!A2,Sheet3!A1), 2)
It doesn't seem to work then.