Technical forums » Office applications »
Pages in topic:   < [1 2]
Remove duplicate rows in Excel
Thread poster: Samuel Murray
Daniel Frisano
Daniel Frisano  Identity Verified
Italy
Local time: 02:02
Member (2008)
English to Italian
+ ...
  Mar 21, 2021

I must be really dumb. Why use a grand total of TWO functions when you can nest them into one?

Untitled-4

Hans Lenting
 
mikhailo
mikhailo
Local time: 03:02
English to Russian
+ ...
re Mar 22, 2021

1. Add column (A) to list and add numeration (to restore original order)
2, Sort list by colums with segments (B)
3. In the next column (C) in 2 row (C2 cell) (A - numeration, B - segments) add formula "=OR(B2=B1;B2=B3)". Replicate formula to row. (using small square in a bottom right corner of the cell)
4. Copy C column and paste as values
5. Sort list by C column and remove all TRUE.
6. Sort list by A column
7. Remove A column
 
Tjasa Kuerpick
Tjasa Kuerpick  Identity Verified
Slovenia
Local time: 02:02
Member (2006)
Slovenian to German
+ ...
Use asap utilities Mar 22, 2021

it has tons of useful functions and is free for non-commercial users, including remove duplicates (case-sensitive and not case-sensitive)
Link: https://www.asap-utilities.com/asap-utilities-excel-tools.php?lang=en_us
 
Silke Walter
Silke Walter  Identity Verified
Germany
Local time: 02:02
Member (2014)
English to German
Simply "Remove Duplicates" Mar 22, 2021

You are right, Samuel.

Excel offers a simple solution:

In "Data" you can click on "Remove duplicates", choose the column(s), click on "OK".

[Edited at 2021-03-22 17:40 GMT]
 
Daniel Frisano
Daniel Frisano  Identity Verified
Italy
Local time: 02:02
Member (2008)
English to Italian
+ ...
Nope Mar 22, 2021

Silke Walter wrote:

In "Data" you can click on "Remove duplicates", choose the column(s), click on "OK". That's all.



Not really. Samuel wants to end up with:
Two
Four

What you get is quite different.

Silke Walter
 
Silke Walter
Silke Walter  Identity Verified
Germany
Local time: 02:02
Member (2014)
English to German
Reading vs. Translating... Mar 22, 2021

Of course. When translating or proofreading etc. I am more than meticulous. In this case I should have looked twice...

Maybe use a Pivot table as a starting point? There all terms/phrases can be listed, including the number of their occurrence.
 
Samuel Murray
Samuel Murray  Identity Verified
Netherlands
Local time: 02:02
Member (2006)
English to Afrikaans
+ ...
TOPIC STARTER
@Narcis Mar 23, 2021

Narcis Lozano Drago wrote:
=OR(EXACT(A1,A2),EXACT(A2,A3))


I confirm that this works.
 
Pages in topic:   < [1 2]


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Remove duplicate rows in Excel






Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »