How to find duplicate numbers in a column

[zone709]

HI trying to find the fastest way i can find duplicate numbers in column BQ. Meaning i have like 500 lines of numbers in BQ. Just want to find out whats duplicting. So if 6 and 6 are in column BQ i want to know this in a quick way.

 

[gaz_chops]

Re: ? How to find duplicate numbers in a column

Use conditional formatting to highlight duplicates.

 

[Joe4]

Re: ? How to find duplicate numbers in a column

One way is to use Conditional Formatting to highlight the duplicate values.
Let's say that your values are in cells BQ1:BQ500. Then select this range, and enter this Conditional Formatting formula:

=COUNTIF($BQ$1:$BQ$500,$BQ1)>1

and choose a color to highlight.

 

[gaz_chops]

Re: ? How to find duplicate numbers in a column

The built in rule will do the same without the formula - "Format only Unique or Duplicate values" then select Duplicate.

 

[zone709]

Re: ? How to find duplicate numbers in a column

Thanks guys

 

[gaz_chops]

Re: ? How to find duplicate numbers in a column

You're welcome.

 

[Joe4]

Re: ? How to find duplicate numbers in a column

The built in rule will do the same without the formula - "Format only Unique or Duplicate values" then select Duplicate.

You mean I have been doing it the hard way over all these years!?!?!
I am so used to using Formulas all the time, I seldom look at the other options. Maybe I should start!