Duplicates On Spreadsheets

  steviegee 08:14 14 Nov 2007

I have 1000's of different cells on a spreadsheet. Is there a formula I can apply to the entire sheet (well just column 'B' really) so that it advises me of any duplicated numbers, like changing colour or something? Thanks.

  johnnyrocker 08:18 14 Nov 2007

what about using the find feature?


  Noldi 08:20 14 Nov 2007

click here


  steviegee 08:33 14 Nov 2007

I can't use the find feature as like I said there are thousands of different possibilities. And Noldi thanks but I can only access certain websites so I can't read your link.

  steviegee 11:20 14 Nov 2007


  Noldi 12:04 14 Nov 2007

My link was to the Microsoft excel help page. Searching "Find duplicate cells"


  VoG II 12:56 14 Nov 2007

Select your data. Format > Conditional formatting, select Formula Is and enter


then set your format and OK your way out.

  steviegee 13:38 14 Nov 2007

That worked a treat thanks VoG.

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 ?