UNIQUE Function – Remove duplicates with formulas UNIQUE is a new Excel function to remove automatically the duplicates in a list of data. It's amazing how simple is it to use this function