Versions Compared

Old Version 14

changes.mady.by.user Ayla Reith Thioye

Saved on

compared with

New Version Current

changes.mady.by.user Gillian Javetski

Saved on

Key

  • 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.  

...