Checking and matching data

  Pedro Campos 19:29 27 May 2005
Locked

I have a list of names and addresses on a Excel sheet and everyday i am entering new data which i take from business cards given to me by my customers. is there a way of checking if, when i enter a new name, it checks all the other entries to see if is already in that list, so that i don't have repeated entries?

  DieSse 21:57 27 May 2005

I presume you keep sorting the entries - in which case a quick look should show duplicates immediately.

  VoG II 22:06 27 May 2005

Yes, you can easily do this using VBA.

Presumably your other homework is now sorted.

  Pedro Campos 12:09 28 May 2005

Thanks I know what you mean, but I would like to see if the new entry is a duplicate as soon as I start typing the name which is the first field. And VoG, what is the story with VBA? you must be a VBA specialist as you have helped me before with Macros...

  Pedro Campos 12:09 28 May 2005

Thanks I know what you mean, but I would like to see if the new entry is a duplicate as soon as I start typing the name which is the first field. And VoG, what is the story with VBA? you must be a VBA specialist as you have helped me before with Macros...

  VoG II 12:48 28 May 2005

As you are entering the data, Excel should offer to auto-complete it for you. That should indicate when you are typing in a duplicate.

The easiest way to remove duplicates id to install ASAP Utilities click here and use "Conditional row and column select, hide or delete" on the Columns/Rows menu.

Alternatively you could use a Worksheet_Change macro to detect an entry and compare it with all existing entries - whilst this should be relatively easy for you to code, I think that it might be fairly slow.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone