Announcement

Collapse
No announcement yet.

Rank On Multiple Criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: Rank On Two Criteria

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

    G.

    Comment


    • #3
      Re: Rank On Two Criteria

      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

      Comment


      • #4
        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!

        Comment


        • #5


          Re: Rank On Two Criteria

          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.

          Comment

          Working...
          X