1. C

    display data without duplicates

    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...

Some videos you may like

This Week's Hot Topics