I have the following rank equation but the results are 1.01 / 2.01 / 3.01 for 1st, 2nd & 3rd rank - how can I get the result to be whole numbers? Format cell visually gets me there but wonder if the is something I can add to the equation
Please Login or Register to view this content.
Last edited by clundeen; 10-25-2011 at 05:47 PM.
Not sure why you're dividing by 100, for unique ranks try this formula in row 3 copied down
=RANK(G3,G$3:G$84,0)+COUNTIF(G$3:G3,G3)-1
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks