Finding Duplicates In Excel

  steviegee 11:30 06 Sep 2007
Locked

I have a column with about 2000 rows with data in each cell. Is there a formula that will highlight all cells that have any duplicates (each cell should have different entries). For example if they were 1-2000 it would colour in red any that had 1, 2, 3 and 3 again?!

  Noldi 12:26 06 Sep 2007

click here

Noldi

  steviegee 12:37 06 Sep 2007

Thanks

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?