Hlo,
I have alist in which a location is mentioned multiple time..
eg:
Delhi
Delhi
Delhi
Punjab
Punjab
Mumbai
Mumbai
I need a data validation in which a location should come only once...
Thank you in advance
Hlo,
I have alist in which a location is mentioned multiple time..
eg:
Delhi
Delhi
Delhi
Punjab
Punjab
Mumbai
Mumbai
I need a data validation in which a location should come only once...
Thank you in advance
post a sample file which will be easier to understand....
Create a unique list using Advanced Filter or formula and use this list for your validation list
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
here is the example....
Formulas to create a Unique list
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Another method
In D6 copied down
=IFERROR(INDEX($C$6:$C$12,MATCH(0,INDEX(COUNTIF($D$5:D5,$C$6:$C$12),0,0),0)),"")
Then name your new list CityList
=Sheet1!$D$6:INDEX(Sheet1!$D$6:$D$12,SUMPRODUCT(--(LEN(Sheet1!$D$6:$D$12)>0)))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
is it possible to get the data validation without any list reference.....
if possible data validation directly from list..without duplicate...if macro is possible then it will be awesome...
Thanks in advance for help...
The easiest way is this:
Take your values and paste them in a sheet.
Remove the duplicates with one click (from Data).
Then put this array in your data validation list.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks