I donot want to make double entry in excel sheet?

[Abdul Rauf Khan]

I scan 50000 ID card Numbers in excel sheet but some of them scanned double
or triple how I can check them that which entries are scanned double so that
I may delete them from data?

 

[Jacob Skaria]

Hi Rauf

If you have the card numbers in ColA ; in Col B cell B1 enter the below
formula

=COUNTIF("$A$1:$A$50000",A1)

Copy the formula down. This will give you the count of each number. Identify
the ones for which the count if more than 1 and delete from top. Remember you
juse need to delete an entry with a value of 2 only once.

If you are looking at generating a unique list of card numbers use
AdvancedFilter

Why dont you try Advanced Filter option. Suppose you have data in Sheet1;
and you want the unique list in Sheet2.

1. Assign a header to your column.
2. From menu Data>Filter>Autofilter and 'Copy to another location'.
3. In list range type/select the range Sheet1!A1:A50000
4. In copy to type/select cell C1
5. Check 'Unique records only'
6. Click OK will give you the unique list in Column C


If this post helps click Yes

 

[Mradul Garg Chartered Accountant]

Hi Rauf

If you have the card numbers in ColA ; in Col B cell B1 enter the below
formula

=COUNTIF("$A$1:$A$50000",A1)

Copy the formula down. This will give you the count of each number. Identify
the ones for which the count if more than 1 and delete from top. Remember you
juse need to delete an entry with a value of 2 only once.

If you are looking at generating a unique list of card numbers use
AdvancedFilter

Why dont you try Advanced Filter option. Suppose you have data in Sheet1;
and you want the unique list in Sheet2.

1. Assign a header to your column.
2. From menu Data>Filter>Autofilter and 'Copy to another location'.
3. In list range type/select the range Sheet1!A1:A50000
4. In copy to type/select cell C1
5. Check 'Unique records only'
6. Click OK will give you the unique list in Column C


If this post helps click Yes

 

[Mradul Garg Chartered Accountant]

I scan 50000 ID card Numbers in excel sheet but some of them scanned double
or triple how I can check them that which entries are scanned double so that
I may delete them from data?

Dear you can use =countif(A$1:A$50000,A1)