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: 03:42
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: 04:42
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: 03:42
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: 03:42
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: 03:42
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: 03:42
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: 03:42
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






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »