If I have a series of data:
Col. A Col. B
Team 1
Team 2
Team 2
Team 1
Team 3
Team 5
Team 3
Team 4
...
In column A say I have 50 entries with 5 teams where there is alot of duplicates, is there a formula that I can put in B1 (assuming Team 1 is in cell A1) that will look in column A...