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

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

## Comment