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

iPhone X review

How to find a font: Discover the name of a typeface with these apps

The best iPhone for 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)