rank/small with multiple ranges

[dave]

I'd like to refer to 3 different ranges of numbers and
make a new list which(when copying down the formula)
creates a list of all the numbers in ascending order. Can
I use the rank function across multiple ranges?

say a1-a10, c1-c10, and e1-e10(so you can't highlight the
whole rnge in one shot)

and make g1 show the smallest number in all the ranges, g2
show the second smallest, etc.

tia,
Dave

 

[Bob Umlas]

Enter this & fill down 30 rows:
=LARGE(($A$1:$A$10,$C$1:$C$10,$E$1:$E$10),ROW(A1))

 

[dave]

thanks - I switched it to small for my purposes. Perfect!