Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Rank On Multiple Criteria

  1. #1
    Join Date
    7th November 2006
    Posts
    7

    Rank On Multiple Criteria

    I work within the sporting field and wish to rank athetes performances (column Z) based on their date of competition (Column M),and the discipline performed (Column O).
    i.e if (M$2:M$100=M4) & (O$2:O$100=O4) then RANK(Z4,Z$2:Z$100). It will work based on one criteria with =SUMPRODUCT(--(M$2:M$100=M2),--(Z2< Z$2:Z$100))+1 but not if I add a second.

    Any help would be appreciated

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th October 2006
    Location
    Australia
    Posts
    287

    Re: Rank On Two Criteria

    I'd hazard a guess that you have forgotten to attach your (small) file, swagman.

    G.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th November 2006
    Posts
    7

    Re: Rank On Two Criteria

    Quote Originally Posted by GeorgS
    I'd hazard a guess that you have forgotten to attach your (small) file, swagman.

    G.
    Sorry George, original file was far to big to post. I have attached a modified file, in which I want to rank results in Column G aginst the date of performence (Column A) and boat class (Column D).

    Regrads
    Swagman
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    4th July 2004
    Location
    Canada
    Posts
    2,292

    Re: Rank On Two Criteria

    Try...

    B2, copied down:

    =SUMPRODUCT(--($A$2:$A$210=A2),--($D$2:$D$210=D2),--(G2<$G$2:$G$210))+1

    Hope this helps!

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    7th November 2006
    Posts
    7

    Re: Rank On Two Criteria

    Quote Originally Posted by Domenic
    Try...

    B2, copied down:

    =SUMPRODUCT(--($A$2:$A$210=A2),--($D$2:$D$210=D2),--(G2<$G$2:$G$210))+1

    Hope this helps!
    Thanks Domenic, worked a treat.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Calculate Rank Based on Criteria
    By NathanHindmarsh in forum EXCEL HELP
    Replies: 21
    Last Post: October 27th, 2011, 11:44
  2. Rank Numbers Based On Criteria
    By novakj in forum EXCEL HELP
    Replies: 2
    Last Post: March 28th, 2008, 11:20
  3. Rank Based On 2 Criteria
    By KjBox in forum EXCEL HELP
    Replies: 5
    Last Post: March 17th, 2008, 16:08
  4. Rank With Multiple Criteria
    By Upside in forum EXCEL HELP
    Replies: 2
    Last Post: October 17th, 2007, 05:29
  5. Replies: 5
    Last Post: October 23rd, 2006, 18:54

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
  •  
porno