I'd hazard a guess that you have forgotten to attach your (small) file, swagman.
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
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).Originally Posted by GeorgS
There are currently 1 users browsing this thread. (0 members and 1 guests)