Please can someone help with my If statement?
Within a pivot table i have 388 football team names in my count and multiple dates in my columns, what i need to do is find out the teams that have recently registered and those who have dropped out. I have been using the following without much joy?? to find the drop outs, but the reverse does not seem to work for the new teams can you help?
=if(=IF('Weekly Pivot'!C6="1",'Weekly Pivot'!C6="0",'Weekly Pivot'!B7)
Thanks
Bookmarks