Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. In a new tab, copy - paste your original column with duplicates into column A
  2. Copy - paste your new cleaned up column into column B
  3. In column C, enter the following countif equation: "=COUNTIF(B1:B800, A1)"
  4. 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.