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: 17:10
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: 18:10
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: 17:10
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: 17:10
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: 17:10
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: 17:10
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: 17:10
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






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »