Results 1 to 5 of 5

Ranking

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2011
    Location
    kano,Nigeria
    MS-Off Ver
    Excel 2007, 2010 ,2013
    Posts
    32

    Question Ranking

    please can some one help me with a rank formula if have data like 5,8,9,1,3,0 from column A1 to A6.i want the rank to appear in B1 then i Will autofill the rest but the ranks should be in this format (1st,2nd,3rd.....) not 123... and if a cell is empty,its rank should be excluded and appears empty too.help me with a formula pls.thanks in advance
    Last edited by ENEMALI; 08-07-2011 at 12:29 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1