Popular Help Content
- In a new tab, copy - paste your original column with duplicates into column A
- Copy - paste your new cleaned up column into column B
- In column C, enter the following countif equation: "=COUNTIF(B1:B800, A1)"
- In any row that has the value "2" in column C, the column A value is a duplicate
How to (very) quickly fill in a column with a value or a formula:
If you want to quickly pull down a single value, you can double click (don’t drag) on the bottom right corner and the value will fill in bellow for all rows where there is information next to it.