[Solved] Find duplicate content

Discuss the spreadsheet application
Post Reply
dnnyanu@gmail.com
Posts: 1
Joined: Tue Dec 06, 2022 8:37 am

[Solved] Find duplicate content

Post by dnnyanu@gmail.com »

How to find duplicate content in different columns or rows in oo calc
 Edit: Changed subject, was calc
Make your post understandable by others 
Last edited by MrProgrammer on Fri Dec 16, 2022 9:58 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] several solutions provided; no follow-up questions from OP -- MrProgrammer, forum moderator
Open office 4.1
User avatar
Zizi64
Volunteer
Posts: 11511
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Find duplicate content

Post by Zizi64 »

You can use these features to indicate duplicates:

- Find an Replace (Find All)
- Conditional Format feature
- Helper cells with function MATCH()
- Your own Macro
- etc...

Please search in the Forum - there are many questions, tips and solutions related this task.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply