locating duplicate barcodes in a large stack of barcodes

Hi I have a bunch of papers at my work to sort through and each paper has an individual  barcode number printed at the bottom. I have to try to locate any duplicate sheets, so the easiest way I think is to just scan all the barcodes (about 500 pages). I know I can scan them all into excel and then arrange them so they are in order by number, and then just see if I see any numbers with duplicates, but I was wondering if there is an easier way, such as maybe if I can scan them into a program that will alert me (with a pop up window or a red flag) if the same barcode is scanned more then once? does anyone know of such a program?
LVL 1
hydrive1902Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
If your barcodes are in column A then

Select A2:A1000  (or whatever extent you choose)
from the home tab select conditional formatting > New rule
select Use a formula to determine which cells to format
in the box for Format values where this formula is true type
=MATCH(A2,$A$1:A1,0)
click on the format button
select the Fill tab
select a color like red
click OK
click OK
0
akbCommented:
Just scan your codes into column A. If there is a duplicate it will tell you in column B. See attached spreadsheet.
Duplicates.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EirmanChief Operations ManagerCommented:
The attached sheet counts the number of duplicates in column A if any.

As duplicates are added/removed, previous values will increase/decrease where appropriate.
CountDuplicate.xls
0
EirmanChief Operations ManagerCommented:
I am very interested in this subject.

I had a live chat with this company and they definitely confirmed
that a duplicate exclusion option exists during scanning.

https://www.codereadr.com/kb/content/4/8/en/creating-a-service.html
0
hydrive1902Author Commented:
thank you everyone!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.