Finding Duplicates In Excel

  steviegee 11:30 06 Sep 07
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 07

click here

Noldi

  steviegee 12:37 06 Sep 07

Thanks

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…