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