Finding duplicate values in the same column

[cwilliams96]

I have 2 columns A & B

in column B there are hundreds of values but some of them potentially may be the same.

I wanted to have in say column A a flag that tells me if the value in column B exists elsewhere in the column B

i.e
A B
26548
15487
14789
45789
EXISTS 26548
72628

 

[wob]

in cell C1 put in the formula

=countif(B:B,B1)

and copy the formula down.

Any values greater than 1 are have been duplicated.

 

[cwilliams96]

Sorry I may have not expained correctly, the values in col B are letters and numbers

eg

JSC-34-352729

I wanted to put a phrase in the column a next to the duplicate value

 

[pagrender]

Using Wob's formula:
=IF(COUNTIF($B$1:B1,B1)>1,"EXISTS","")

Paste this formula into cell A1 and drag it down. If your data starts in a different cell (A2, for example), change the cell references.

Pete

 

[wilcowoods]

I have 2 columns A & B

in column B there are hundreds of values but some of them potentially may be the same.

I wanted to have in say column A a flag that tells me if the value in column B exists elsewhere in the column B

i.e
A B
26548
15487
14789
45789
EXISTS 26548
72628

Or you could use conditional formatting / highlight cell rules / duplicates if you just want to highlight the duplicate number!