rank and percentrank error - please help!

[tina]

Hello Group,

I am using the rank funcion in excel 2000 but it doesn't
give me an ordered (1,2,3....) rank. I also tried the %
rank, first but the percentrank function in excel gives
me a #Div/0 error. Please help.

Here's what I have:
Product Sales (A) Rank (B)
2612 3
1967 4
5802 3
1480 4
1552 3
6255 2
1443 2
352 2
21462.67 (total)

Thanks,

Tina

 

[Mark Graesser]

I believe your problem is from when you copied the formula. If the top formula had Relative References then your range has changed on the subsequent copies of the formula. You can prevent this by using an Absolute reference for the range. Try:

=RANK(A1,$A$1:$A$8)

In your first cell. When you copy it down the range won't change.

Good Luck,
Mark Graesser
(e-mail address removed)

 

[Tina]

Thank you.

-----Original Message-----
I believe your problem is from when you copied the

formula. If the top formula had Relative References then
your range has changed on the subsequent copies of the
formula. You can prevent this by using an Absolute
reference for the range. Try: