Assuming that your data are in column A (starting at A2), and you want the
rankings to go to column B, in B2 enter
=if(and(row(A2)50,row(A2)<150),"",rank(A2,($A$2:$ A$50,$A150:$A$200)))
and fill in the formula for the rest of the column B (i.e., till B200).
Please note that this formula will give equal ranks for ties.

B.R.Ramachandran

"Andrew" wrote:

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