Irazor
asked on
Excel checking if teams have appeared in previous yeas
Hi all,
I wanted to check if the teams this year have played in all the five previous years. I've attached a spreadsheet to show you what I've done. What I'm doing isn't working which is why I'm asking for help. I've used the function below.
=SUMPRODUCT(--('7-8'!$D$2: $D$307=B2) ,--('8-9'! $D$2:$D$30 7=B2),--(' 9-10'!$D$2 :$D$307=B2 ),--('10-1 1'!$D$2:$D $307=B2),- -('11-12'! $D$2:$D$30 7=B2))
B2 would be the team names cell.
The thing is that I had it working only for the bottom 3 teams at one stage but I know there are more teams that qualify.
Any help gratefully received.
Regards to all.
Dave
Team-count-over-the-previous-5-y.xls
I wanted to check if the teams this year have played in all the five previous years. I've attached a spreadsheet to show you what I've done. What I'm doing isn't working which is why I'm asking for help. I've used the function below.
=SUMPRODUCT(--('7-8'!$D$2:
B2 would be the team names cell.
The thing is that I had it working only for the bottom 3 teams at one stage but I know there are more teams that qualify.
Any help gratefully received.
Regards to all.
Dave
Team-count-over-the-previous-5-y.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER