Page 1 of 1
[Solved] Find duplicates
Posted: Sat Nov 09, 2013 1:15 pm
by campanico
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
Re: Find duplicates
Posted: Sat Nov 09, 2013 1:21 pm
by karolus
Hallo
Why not →Data→Filter→Standardfilter....[x]other Target ....[x]without Duplicates
Karolus
Re: Find duplicates
Posted: Sat Nov 09, 2013 2:15 pm
by campanico
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.
Re: Find duplicates
Posted: Sat Nov 09, 2013 2:24 pm
by karolus
Hallo
in B1:
Code: Select all
=IF(COUNTIF($A$1:$A$9999;A1)>1;"Duplicate";"")
an pull down.
Karolus
Re: Find duplicates
Posted: Sat Nov 09, 2013 4:26 pm
by campanico
Great work thank you very much.
Re: Find duplicates
Posted: Sun Jun 09, 2019 2:38 am
by GuccizBud
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.
