MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Double Numbers


Posted by Adam Warner on May 02, 2001 12:47 PM

Hi, I know nothing about programming macros but need to ensure that no two purchase order numbers are the same within one given column. These numbers will include a "-" like "15-000123" and "15-000124 is there a validation technique that will take this into consideration?
Thanks
Adam


Posted by lenze on May 02, 2001 2:36 PM

See Chip Pearson's Excellent Site
http://www.cpearson.com/excel/NoDupEntry.htm

Posted by Dave Hawley on May 02, 2001 11:46 PM


Hi Adam

There are some examples of how to avoid/remove/highlight duplicates on my WebSite under "Handy Hints".

As it sais though "Validation" will NOT prevent users from pasting in a duplicate, if this should be an issue let me know and I'll write a quick macro.


Dave

OzGrid Business Applications