Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Micro Excel

  • Please log in to reply




  • Member
  • PipPip
  • 25 posts
Ok I work with excel alot doing scanning barcodes on cell phones. And a lot of the time we get a shipment in & we scan the codes directly off the master carton. The problem lies with the fact that sometimes the cell phone companies duplicate a number on different boxes.

Which leads me to my question: Is there a way in which I can use Excel to alert me if I have a duplicate code? Or do I have to use a different program?

  • 0


Pi rules

Pi rules


  • Member
  • PipPipPip
  • 634 posts
I found code for a macro (a small program that executes commands) here that you could try out. It colors the duplicates in red.

I also found this which contains a formula that you could copy for each row that says whether or not the value is unique.
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP