How to remove duplicate rows in excel or notepad++?

J

JiJo2018-03-12 19:37:13

excel

JiJo, 2018-03-12 19:37:13

The file contains duplicate lines. How to remove not just duplicates, but completely remove lines along with duplicates?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Anton Kiselyov, 2018-03-12
@zamboga

Suppose duplicate values are in column A.
In a new empty column, for example, B, we drive the formula into cell B2 and drag it down:
B2: =COUNTIF(A:A;A2) - the formula looks in column "A" for how many times the value occurs cell A2.
B3: = COUNTIF (A: A; A3) - the formula looks in column "A" for how many times the value of cell A3 occurs.
etc.
After that, we apply a filter on column B: unique values - will be the number 1, duplicates - will be 2 or more.
We remove unnecessary.

V

v_roger, 2018-03-26
@v_roger

There is a good article here on how to remove duplicates in Excel.