+ Reply to Thread
Results 1 to 6 of 6

Ranking issue.

Hybrid View

  1. #1
    Registered User
    Join Date
    07-30-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Ranking issue.

    Thanks for your quick response.
    Column D is formatted dd.mm.yy
    I changed to dd.mmm.yy and inputted your array formula in cell F2. Unfortunately received #Value!
    Sorry but I am not familiar with "array formulas"
    Could you have another look?
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Ranking issue.

    Put on F2 and copie down:

    =IF(G2>1," ",(IF(AND(E2=0,G2=0)," ",COUNTIF($E$2:$E$5,"<"&E2))))
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-30-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Ranking issue.

    That's done it.
    Thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ranking Issue
    By gamefreak in forum Excel General
    Replies: 1
    Last Post: 12-02-2014, 01:00 PM
  2. [SOLVED] Help with #value! issue in ranking formula
    By BitterGreg in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2014, 04:13 PM
  3. Ranking (weighted) issue
    By jw01 in forum Excel General
    Replies: 4
    Last Post: 09-07-2011, 08:10 PM
  4. Ranking Issue
    By IdRatherBeCoding in forum Excel General
    Replies: 2
    Last Post: 05-23-2011, 11:28 AM
  5. Ranking Issue
    By acg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2007, 05:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1