Finding Duplicates In Excel

  steviegee 11:30 06 Sep 2007

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


  steviegee 12:37 06 Sep 2007


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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?