Ranking Errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I make a rank equation that omits particular cells? 1
Rank Function Help Needed 7
Advanced(!) Ranking 1
Rank Error in Pivot Table 2
Ranking Top 5 in score and percentage 1
Sumproduct - Return value as Blank 3
Different perspective of RANK 4
Ranking Formula Question 5

Back
Top