excel visual basic training - 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