How to remove duplicates automatically in excel?

Question

I have two files, File A and File B.

I copied File A, Column A's data into File B, Column A
I want to remove Duplicate Values from Column A when I paste into File B (without using VBA would be much better).

Thank you

Or the other option that I am using Countif to count the total values in Column A but is it possible to add additional criteria in Countif function to count only unique values? — Hassan Arshad, Feb 13 '19 at 00:15
This is not a programming question. You are actively trying to avoid writing code. You might get some better help on SuperUser for this. — Buggabill, Feb 13 '19 at 00:33
@Buggabill I am new to this how can I move this to SuperUser? — Hassan Arshad, Feb 13 '19 at 00:36

score 1 · Answer 1 · answered Feb 13 '19 at 00:09

1

Select Column A data and goto 'Data' menu and inside this menu you will find 'Remove Duplicates' button. Click this and it will delete duplicate rows.

answered Feb 13 '19 at 00:09

Gopi

620
8
16

Hi, Thank you but I know this option I am trying to do so when I paste the list into Column A, only unique values paste. – Hassan Arshad Feb 13 '19 at 00:11
That's not a built-in feature. You'll have to code for that. – n8. Feb 13 '19 at 00:15

How to remove duplicates automatically in excel?

1 Answers1