"Abdul Rauf Khan" wrote:

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)