LinkBack URL
About LinkBacks
Does anyone know how to get rid of duplicate values in validation dropdown menu. Im using a range for the list that has a lot of repetative values. I want to have only unique ones in the list.
Any ideas...
Thanks in advance!
Validation rule dropdown list without duplicate values
Does anyone know how to get rid of duplicate values in validation dropdown menu. Im using a range for the list that has a lot of repetative values. I want to have only unique ones in the list.
Any ideas...
Thanks in advance!
Maintain unique selections in a separate list - it makes it much more simple to maintain and manage.Any ideas?
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
You can quickly get the "unique values" from a long range of values into another column using the Data > Filter > Advanced Filter.... copy to another location>unique values only.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks. Good ideas. Didn't know about advanced filter option.
Problem is i will be updating my main sheet all the time, and it will be a bit difficult to manage all this data (copy filtered). Is there a way maybe to automate updating filtered unique values.
Hi
....OR... take a look, here!
http://www.excelforum.com/excel-2007...down-list.html
Hope to helps you.
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.
You can use the Advanced Filter to get the values in place the first time. Then from there you can employ a macro in the background to watch what you do on Sheet1 in column A to update your Sheet2 column A list and add any new values that you enter.
This is the basic idea, I've used it many times. I'm sure it will need tweaking for your real scenario:
Please Login or Register to view this content.
First of all thanks for the code. I think this will solve my problem, when i get it to work (need this for 4 or 5 columns).Originally Posted by JBeaucaire
You can use the Advanced Filter to get the values in place the first time. Then from there you can employ a macro in the background to watch what you do on Sheet1 in column A to update your Sheet2 column A list and add any new values that you enter.
This is the basic idea, I've used it many times. I'm sure it will need tweaking for your real scenario:
Please Login or Register to view this content.
Also i have been inserting macro functions in worksheets many times but this one eludes me. Can you please tell me if this one needs "special care".
The sheet that this needs to be active in...
1) Right-click the sheet tab and select VIEW CODE (this will open the sheet module)
2) Paste in the code given, make your tweaks.
Note: there can only be ONE worksheet_change macro in the sheet module, so if you need it to do more things in more columns, the one macro must be expanded to do the work. You mention you need this on many columns... what columns? And where do the values for each column watched transfer to on the other sheet?
I have managed to make it work on one row. I want to do this for five rows (A,B,C,D,E one next to each other), and make this rows update unique values in sheet2 in the same rows as in sheet1.
Did you get this all sorted out? Sorry I missed your last post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks