Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel visual basic training - Data Validation
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel visual basic training - Data Validation
Resolved · Low Priority · Version Standard
Reply Fri 1 Feb 2008, 16:43Delegate Haninder said...
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
For upcoming training course dates see: Pricing & availability
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
|