rank/small with multiple ranges
 

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

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

"dave" wrote in message
...
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

thanks - I switched it to small for my purposes. Perfect!
-----Original Message-----
Enter this & fill down 30 rows:
=LARGE(($A$1:$A$10,$C$1:$C$10,$E$1:$E$10),ROW(A1) )

"dave" wrote in
message
...
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


.