This formula checks a columns in a list for duplicates. In this case the column header of the column being checked is called MachineName. This formula is put in each cell of the adjacent column and identifies if each entry is unique or a duplicate
=IF(COUNTIFS([MachineName], [@MachineName]) > 1, "Duplicate", "Unique")
