Technická fóra » Office applications »
Stran v tématu:   < [1 2]
Remove duplicate rows in Excel
Autor vlákna: Samuel Murray
Daniel Frisano
Daniel Frisano  Identity Verified
Itálie
Local time: 00:12
Člen (2008)
angličtina -> italština
+ ...
  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: 01:12
angličtina -> ruština
+ ...
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
Slovinsko
Local time: 00:12
Člen (2006)
slovinština -> němčina
+ ...
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
Německo
Local time: 00:12
Člen (2014)
angličtina -> němčina
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
Itálie
Local time: 00:12
Člen (2008)
angličtina -> italština
+ ...
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
Německo
Local time: 00:12
Člen (2014)
angličtina -> němčina
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
Nizozemsko
Local time: 00:12
Člen (2006)
angličtina -> afrikánština
+ ...
AUTOR TÉMATU
@Narcis Mar 23, 2021

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


I confirm that this works.
 
Stran v tématu:   < [1 2]


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

Moderátor/moderátoři tohoto fóra
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






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

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 »