Duplicates On Spreadsheets

  steviegee 08:14 14 Nov 2007
Locked

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?



johnny.

  Noldi 08:20 14 Nov 2007

click here

Noldi

  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"

Noldi

  VoG II 12:56 14 Nov 2007

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

=COUNTIF(B:B,B1)>1

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 ?