Results 1 to 11 of 11

Issue with Rank Count Formula

Threaded View

  1. 08-14-2014, 03:14 PM #1
    Doofus1
    Doofus1 is offline
    Forum Contributor
    Join Date
    06-04-2014
    Location
    Nevada, USA
    MS-Off Ver
    2019
    Posts
    345

    Issue with Rank Count Formula

    Hi Folks,
    I have attached an excel 2010 spreadsheet to show the issue.
    I was shown a formula to rank a series of numbers =RANK(A2,$A$2:$A$19775,0).
    However, the ranking figure that get's generated, appears to be counting the cells or something like that.

    This is all hurting my pretty little head.

    Any helpful suggestions (regarding the fixing of the formula) would be greatly appreciated.

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Having an issue with a formula used to rank column numbers earlier but now is failing .
    By Securitysports in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-02-2013, 06:04 PM
  2. [SOLVED] text count issue, it seems to count the formula also?
    By randypang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2013, 03:27 AM
  3. Formula to Rank and populate values base don Rank
    By Excel Dumbo in forum Excel General
    Replies: 3
    Last Post: 10-09-2012, 02:02 AM
  4. Count +if function formula issue.
    By pdmkh in forum Excel General
    Replies: 3
    Last Post: 10-04-2009, 11:11 AM
  5. Count formula issue
    By mevetts in forum Excel General
    Replies: 8
    Last Post: 01-29-2006, 06:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1