Tag Info

New answers tagged


I found a way to do it: Select Column A and "Insert 1 left" to add a column. Your table data is moved over one to columns B - D. In your newly blank Cell A2, enter formula =IF(COUNTIF($B$2:$B2,B2)=1, "Unique", "Duplicate") Copy the formula from A1 and paste it down the A column range for as far as you have data. The "$" absolute references will ensure ...

Top 50 recent answers are included