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, and list only the values without the duplicates, looking like this:
Col. A Col. B
Team 1 Team 1
Team 2 Team 2
Team 2 Team 3
Team 1 Team 4
Team 3 Team 5
Team 5
Team 3
Team 4
...
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, and list only the values without the duplicates, looking like this:
Col. A Col. B
Team 1 Team 1
Team 2 Team 2
Team 2 Team 3
Team 1 Team 4
Team 3 Team 5
Team 5
Team 3
Team 4
...
