Hello,
Looking at the November tab on the attached you see I have a list of colors that are data validated from the 1st Tab, in a column A. I have a list like this I have to do every month. It is a lot longer and the types change.
I'm trying to make an error for a repeated word in a column. So if i'm going down the list in December and I try to select blue again I want an error or maybe have it set up in a way so the word doesn't get repeated.
Let me know your thoughts!
Administrative Note:
Welcome to the forum.
Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.
With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).
Thank you for helping us to help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
you could use something like this in column C (C4 for example and dragged down) to show an error if it repeats...
=IF(COUNTIF($A$4:A4,A4)>1,"Error","")
But if you want something to indicate it if you select it that might be VBA which requires coding and someone will have to give you code for that (don't have those skills myself).
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
updated!
Last edited by AliGW; 01-03-2020 at 12:34 PM. Reason: Please don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks