Hi!

Use a named range.

Assume "rows 2 - 50 and 150 - 200" means A2:A50 and A150:A200.

Select the first range A2:A50. Hold down the CTRL key and select the second
range A150:A200.

In the Name box enter a name for that combined range. I'll use the name
"range".

Then in say, B2 enter this formula and copy down to B50:

=RANK(A2,range)

Then you would need to enter it again in B150:

=RANK(A150,range)

Biff

"Andrew" wrote in message
...
I have numerous numbers in a column. I want to rank numbers from two
different ranges. Eg rows 2 - 50 and 150 - 200. i have tried selecting
these cells and using the rank formula but it doesnt work.

Can someone tell me if this is possible.

Thanks