Technische forums » Office applications »
Pagina's in het onderwerp:   < [1 2]
Remove duplicate rows in Excel
De persoon die dit onderwerp heeft geplaatst: Samuel Murray
Daniel Frisano
Daniel Frisano  Identity Verified
Italië
Local time: 21:04
Lid 2008
Engels naar Italiaans
+ ...
  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: 22:04
Engels naar Russisch
+ ...
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
Slovenië
Local time: 21:04
Lid 2006
Sloveens naar Duits
+ ...
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
Duitsland
Local time: 21:04
Lid 2014
Engels naar Duits
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
Italië
Local time: 21:04
Lid 2008
Engels naar Italiaans
+ ...
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
Duitsland
Local time: 21:04
Lid 2014
Engels naar Duits
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
Nederland
Local time: 21:04
Lid 2006
Engels naar Afrikaans
+ ...
ONDERWERPSTARTER
@Narcis Mar 23, 2021

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


I confirm that this works.
 
Pagina's in het onderwerp:   < [1 2]


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

Moderator(en) van dit 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! »
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 »