Thread
:
multiple arrays for SMALL command
View Single Post
#
4
Chickalett
Junior Member
Posts: 4
Quote:
Originally Posted by
=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.
Reply With Quote
Chickalett
View Public Profile
Send a private message to Chickalett
Find all posts by Chickalett