Checking and matching data

  Pedro Campos 19:29 27 May 05
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 05

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

  VoG II 22:06 27 May 05

Yes, you can easily do this using VBA.

Presumably your other homework is now sorted.

  Pedro Campos 12:09 28 May 05

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 05

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 05

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…