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
.
|