Help Excel formula eliminate duplicate values and keep only 2 identical rows.

[Nguyen Anh Dung]

as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9 rows,etc.... How to delete duplicate values and keep only 2 rows

link file:

1.csv

drive.google.com

 

[sandy666]

after remove duplicates from 3 columns together: 962
8686 remove duplicates=>481 rows. if keep only 2 rows the same, but columns B and C have different values that do not overlap 962 rows.

could you explain your logic?

1. import your csv into Power Query
2. select all columns (3) - the last one is not important I think
3. use Remove Duplicates
4. count rows

 

[footoo]

not correct. you can help me vba?
link file: test.csv

In your CSV, what are all those 1's in column D ?
You must have entered the formula incorrectly - please note the absolute row ref (A$2):
=IF(COUNTIF(A$2:A2,A2)>2,"d",1)

 

[sandy666]

anyway I think if you do that with footoo's way your data will not be consistent after filtering

 

[Nguyen Anh Dung]

after remove duplicates from 3 columns together: 962 rows or 964

anyway I think if you do that with footoo's way your data will not be consistent after filtering

Yes, i only want remove duplicate but keep two row

 

[sandy666]

sure, your choice
have a nice day

 

[footoo]

anyway I think if you do that with footoo's way your data will not be consistent after filtering

Yes, i only want remove duplicate but keep two row

I give up.
It's still not clear what is required.
And the OP has not tried with the correct formula per my suggestion.

 

[sandy666]

OP has not tried with the correct formula per my suggestion

but I tried and it works

 

[footoo]

but I tried and it works

But the OP needs to check to see if it does what he wants.

 

[sandy666]

OP needs to check

sure

 

[Nguyen Anh Dung]

not correct. you can help me vba?
link file: test.csv

Yes, Best regards and thanks you so much!!!