I have a spreadsheet which includes footballers names and the level of football they have played at over the past years. I want to count all of those who are playing professional however if a single footballer has played for 2 professional clubs it counts as 2 however I just need it to be 1.
From the example below if I count professional it will say 4 however I want it to say 2 as only 2 players have played professional! Any ideas how???
Excel View example-
Player Name, Level Of Football, Season
Dave Hill Professional 2008/09
Dave Hill Professional 2009/10
Dave Hill Semi Pro 2011/12
Dave Hill Professional 2015/16
Joe Bryan Amateur 2008/09
Cristiano Ronaldo Professional 2021/22
Bookmarks