Hi,
I am trying to rank team games based on the date the game was played. (game 42 of schedule..etc) My headers are;
Date Home Away
Jan 25 Toronto Detroit
Jan 26 Chicago New York
Jan 27 LA Toronto
Jan 28 Detroit Chicago
This formula (=COUNTIFS(B:B,B2,A:A,"<"&A2)+1) works when it only has to look for team names in one column, but when I put "B:C:" as the range instead of B:B, I get an error message.
I am trying to rank team games based on the date the game was played. (game 42 of schedule..etc) My headers are;
Date Home Away
Jan 25 Toronto Detroit
Jan 26 Chicago New York
Jan 27 LA Toronto
Jan 28 Detroit Chicago
This formula (=COUNTIFS(B:B,B2,A:A,"<"&A2)+1) works when it only has to look for team names in one column, but when I put "B:C:" as the range instead of B:B, I get an error message.