Haninder has attended:
Excel Advanced course
Data Validation
How do stop repetitive data form occuring when validating cells with restrited data.
i.e Id
e011
e021
e011 - when this value entered again, it should say error due to it already been entered. How do this?
Many Thanks
RE: Data Validation
Hello Haninder,
Hope you enjoyed your Microsoft Excel course with BEST Training.
What you are reffereing to is unique values. As a default in Excel, I do not know of a way you can acheive this, although having said that, there may be on of our trainers that could answer your question.
What I can say is that if you were using Microsoft Access, then you would be able to do this very easily. You would simply set the field to being a Primary Key, or set the property that is called ALLOW DUPLICATES to NO.
This will restrict the data in the field to uniques.
As Excel is more open ended and user friendly, it does not contain that capacity. You may be able to achieve using VBA coding, as then you have access to any part of Excel that you choose.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps
you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
