[Solved] Find duplicates

Discuss the spreadsheet application

[Solved] Find duplicates

Postby 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
:crazy:
Last edited by Hagar Delest on Sat Nov 09, 2013 8:21 pm, edited 1 time in total.
Reason: tagged solved.
OpenOffice 3.1 on Windows 8
campanico
 
Posts: 37
Joined: Wed Nov 06, 2013 4:48 pm

Re: Find duplicates

Postby karolus » Sat Nov 09, 2013 1:21 pm

Hallo

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

Karolus
AOO4, Libreoffice - 5.1 … 5.3.2.2 on Linux Mint17
User avatar
karolus
Volunteer
 
Posts: 843
Joined: Sat Jul 02, 2011 9:47 am

Re: Find duplicates

Postby 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.
OpenOffice 3.1 on Windows 8
campanico
 
Posts: 37
Joined: Wed Nov 06, 2013 4:48 pm

Re: Find duplicates

Postby karolus » Sat Nov 09, 2013 2:24 pm

Hallo
in B1:
Code: Select all   Expand viewCollapse view
=IF(COUNTIF($A$1:$A$9999;A1)>1;"Duplicate";"")


an pull down.

Karolus
AOO4, Libreoffice - 5.1 … 5.3.2.2 on Linux Mint17
User avatar
karolus
Volunteer
 
Posts: 843
Joined: Sat Jul 02, 2011 9:47 am

Re: Find duplicates

Postby campanico » Sat Nov 09, 2013 4:26 pm

Great work thank you very much.
:D
OpenOffice 3.1 on Windows 8
campanico
 
Posts: 37
Joined: Wed Nov 06, 2013 4:48 pm


Return to Calc

Who is online

Users browsing this forum: robleyd and 54 guests