[Solved] Find duplicates

campanico · Post by **campanico** » Sat Nov 09, 2013 1:15 pm

Hi all

I am trying to get a formula that shows what values are duplicated in a column and display the message "duplicate" in red,

A D
78
73
64 Duplicate
64 Duplicate
64 Duplicate
63
59
(...)

Can someone help me?
Thanks

Post by **karolus** » Sat Nov 09, 2013 1:21 pm

Hallo

Why not →Data→Filter→Standardfilter....[x]other Target ....[x]without Duplicates

Karolus

campanico · Post by **campanico** » Sat Nov 09, 2013 2:15 pm

I really need to see them all

It is an archery classification table, so the duplicates are needed in other to select archers to the tie brake round.

Post by **karolus** » Sat Nov 09, 2013 2:24 pm

Hallo
in B1:

Code: Select all

=IF(COUNTIF($A$1:$A$9999;A1)>1;"Duplicate";"")

an pull down.

Karolus

campanico · Post by **campanico** » Sat Nov 09, 2013 4:26 pm

Great work thank you very much.

GuccizBud · Post by **GuccizBud** » Sun Jun 09, 2019 2:38 am

karolus wrote:
Hallo
in B1:
Code: Select all
=IF(COUNTIF($A$1:$A$9999;A1)>1;"Duplicate";"")
and pull down.

Karolus

I, um, love you.

[Solved] Find duplicates

[Solved] Find duplicates

Re: Find duplicates

Re: Find duplicates

Re: Find duplicates

Re: Find duplicates

Re: Find duplicates