I am trying to rank salespeople unit sales and I am getting an error I can
not figure out. This is the formula I am using =RANK(C15,Leases) where the
whole column of figures is names leases. Some cells rank fine but some do
not. The cells that seem to not calculate right are decimal numbers like 1.5
or 6.5. Anyone who can help me would be greatly appreciated.

Amy,

There may not be an exact comparison on the numbers you are looking up.
e.g., 1.55 instead of 1.5
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Amy" wrote:

I am trying to rank salespeople unit sales and I am getting an error I can
not figure out. This is the formula I am using =RANK(C15,Leases) where the
whole column of figures is names leases. Some cells rank fine but some do
not. The cells that seem to not calculate right are decimal numbers like 1.5
or 6.5. Anyone who can help me would be greatly appreciated.

Unfortunately, that did not help. the only thing that makes the formula work
is to change it to a whole number which is not true. if this formula will not
work for this purpose is there another formula I can insert instead?

"galimi" wrote:

Amy,

There may not be an exact comparison on the numbers you are looking up.
e.g., 1.55 instead of 1.5
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Amy" wrote:

I am trying to rank salespeople unit sales and I am getting an error I can
not figure out. This is the formula I am using =RANK(C15,Leases) where the
whole column of figures is names leases. Some cells rank fine but some do
not. The cells that seem to not calculate right are decimal numbers like 1.5
or 6.5. Anyone who can help me would be greatly appreciated.