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

OnePlus 5 review

Best of the Grad Shows 2017: UAL Central Saint Martins

MacBook Pro 15-inch (2017) review

Comment connecter un MacBook à une TV ?