| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unique, blank free, editable dropdown...
so i have read about tons of different solutions regarding 1 of the
requirements for my drop down, but i cant seem to put them together to get it to do what i need... i am open to any solution that can provide... a drop down list that does not show any duplicates does not show any blank spaces and allows me to type in the cell that the drop down is in.... i thought this would be the easiest part of my worksheet since i thought it would be built into excel... but its turned out to be the most difficult! ANY HELP is greatly appreciated!! TIA! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique, blank free, editable dropdown...
basically, you would need to build your list in another location using
formulas, then reference that with your Data Validation using the List option. -- Regards, Tom Ogilvy "Nigel" wrote in message oups.com... so i have read about tons of different solutions regarding 1 of the requirements for my drop down, but i cant seem to put them together to get it to do what i need... i am open to any solution that can provide... a drop down list that does not show any duplicates does not show any blank spaces and allows me to type in the cell that the drop down is in.... i thought this would be the easiest part of my worksheet since i thought it would be built into excel... but its turned out to be the most difficult! ANY HELP is greatly appreciated!! TIA! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique, blank free, editable dropdown...
how do i build the list?
On Nov 18, 6:53 pm, "Tom Ogilvy" wrote: basically, you would need to build your list in another location using formulas, then reference that with your Data Validation using the List option. -- Regards, Tom Ogilvy "Nigel" wrote in ooglegroups.com... so i have read about tons of different solutions regarding 1 of the requirements for my drop down, but i cant seem to put them together to get it to do what i need... i am open to any solution that can provide... a drop down list that does not show any duplicates does not show any blank spaces and allows me to type in the cell that the drop down is in.... i thought this would be the easiest part of my worksheet since i thought it would be built into excel... but its turned out to be the most difficult! ANY HELP is greatly appreciated!! TIA! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique, blank free, editable dropdown...
One way would be to use advanced filters, setting options to unique values
only and copying to another location on the worksheet. -- Cheers Nigel "Nigel" wrote in message oups.com... how do i build the list? On Nov 18, 6:53 pm, "Tom Ogilvy" wrote: basically, you would need to build your list in another location using formulas, then reference that with your Data Validation using the List option. -- Regards, Tom Ogilvy "Nigel" wrote in ooglegroups.com... so i have read about tons of different solutions regarding 1 of the requirements for my drop down, but i cant seem to put them together to get it to do what i need... i am open to any solution that can provide... a drop down list that does not show any duplicates does not show any blank spaces and allows me to type in the cell that the drop down is in.... i thought this would be the easiest part of my worksheet since i thought it would be built into excel... but its turned out to be the most difficult! ANY HELP is greatly appreciated!! TIA! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique, blank free, editable dropdown...
http://www.cpearson.com/excel/duplic...tractingUnique
http://www.cpearson.com/excel/noblanks.htm -- Regards, Tom Ogilvy "Nigel" wrote in message oups.com... how do i build the list? On Nov 18, 6:53 pm, "Tom Ogilvy" wrote: basically, you would need to build your list in another location using formulas, then reference that with your Data Validation using the List option. -- Regards, Tom Ogilvy "Nigel" wrote in ooglegroups.com... so i have read about tons of different solutions regarding 1 of the requirements for my drop down, but i cant seem to put them together to get it to do what i need... i am open to any solution that can provide... a drop down list that does not show any duplicates does not show any blank spaces and allows me to type in the cell that the drop down is in.... i thought this would be the easiest part of my worksheet since i thought it would be built into excel... but its turned out to be the most difficult! ANY HELP is greatly appreciated!! TIA! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique, blank free, editable dropdown...
thanks for the links, but i need to my range to be called with
variables, so the excel cell functions dont work...i need VBA code.... i need to set the variable range, and put all the unique values (excluding blanks) to a new list. and somehow i need to know the first and last cell in that new list..... so from the list on the left, to the list on the right......and either name that new list, or get the cell of the last value copied (6 in the example) 1 1 1 2 2 8 8 3 3 4 5 4 6 5 6 4 On Nov 19, 9:35 am, "Tom Ogilvy" wrote: http://www.cpearson.com/excel/duplic...l/noblanks.htm -- Regards, Tom Ogilvy "Nigel" wrote in ooglegroups.com... how do i build the list? On Nov 18, 6:53 pm, "Tom Ogilvy" wrote: basically, you would need to build your list in another location using formulas, then reference that with your Data Validation using the List option. -- Regards, Tom Ogilvy "Nigel" wrote in ooglegroups.com... so i have read about tons of different solutions regarding 1 of the requirements for my drop down, but i cant seem to put them together to get it to do what i need... i am open to any solution that can provide... a drop down list that does not show any duplicates does not show any blank spaces and allows me to type in the cell that the drop down is in.... i thought this would be the easiest part of my worksheet since i thought it would be built into excel... but its turned out to be the most difficult! ANY HELP is greatly appreciated!! TIA! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique, blank free, editable dropdown...
I can appreciate that you personally would probably not be able to implement
a ""cell function solution. I answered you later question on a code based approach. -- Regards, Tom Ogilvy "Nigel" wrote in message ups.com... thanks for the links, but i need to my range to be called with variables, so the excel cell functions dont work...i need VBA code.... i need to set the variable range, and put all the unique values (excluding blanks) to a new list. and somehow i need to know the first and last cell in that new list..... so from the list on the left, to the list on the right......and either name that new list, or get the cell of the last value copied (6 in the example) 1 1 1 2 2 8 8 3 3 4 5 4 6 5 6 4 On Nov 19, 9:35 am, "Tom Ogilvy" wrote: http://www.cpearson.com/excel/duplic...l/noblanks.htm -- Regards, Tom Ogilvy "Nigel" wrote in ooglegroups.com... how do i build the list? On Nov 18, 6:53 pm, "Tom Ogilvy" wrote: basically, you would need to build your list in another location using formulas, then reference that with your Data Validation using the List option. -- Regards, Tom Ogilvy "Nigel" wrote in ooglegroups.com... so i have read about tons of different solutions regarding 1 of the requirements for my drop down, but i cant seem to put them together to get it to do what i need... i am open to any solution that can provide... a drop down list that does not show any duplicates does not show any blank spaces and allows me to type in the cell that the drop down is in.... i thought this would be the easiest part of my worksheet since i thought it would be built into excel... but its turned out to be the most difficult! ANY HELP is greatly appreciated!! TIA! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blank space on dropdown list | Excel Discussion (Misc queries) | |||
| Unique/Distinct Dropdown List | Excel Worksheet Functions | |||
| editable cell in a dropdown list | Excel Worksheet Functions | |||
| Free social world wide network pays for 10 generations! Free! | Excel Discussion (Misc queries) | |||
| Dropdown to populate next blank cell | Excel Programming | |||
![Nigel[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
