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
[Solved] Find duplicates
[Solved] Find duplicates
Last edited by Hagar Delest on Sat Nov 09, 2013 8:21 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Re: Find duplicates
Hallo
Why not →Data→Filter→Standardfilter....[x]other Target ....[x]without Duplicates
Karolus
Why not →Data→Filter→Standardfilter....[x]other Target ....[x]without Duplicates
Karolus
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Re: Find duplicates
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.
It is an archery classification table, so the duplicates are needed in other to select archers to the tie brake round.
Re: Find duplicates
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Re: Find duplicates
Great work thank you very much.
Re: Find duplicates
I, um, love you.karolus wrote:
Hallo
in B1:
and pull down.Code: Select all
=IF(COUNTIF($A$1:$A$9999;A1)>1;"Duplicate";"")
Karolus
Last edited by RusselB on Sun Jun 16, 2019 10:28 pm, edited 1 time in total.
Reason: Implied sexual reference deleted
Reason: Implied sexual reference deleted
OpenOffice 4.1.0
Windows® 7 Pro (64-bit)
Windows® 7 Pro (64-bit)