Unique Data Validation
I have data validation set up to equal text six characters long. Now, I need
to make sure that all values entered are unique. The characters will always be six numbers, but must be unique from any other six numbers in the column. Thanks Jeff |
Unique Data Validation
See http://www.contextures.com/xlDataVal03.html
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "jeffbert" wrote in message ... I have data validation set up to equal text six characters long. Now, I need to make sure that all values entered are unique. The characters will always be six numbers, but must be unique from any other six numbers in the column. Thanks Jeff |
All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com