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!

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!

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!

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!

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!

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!

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!

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



"chelle" wrote in message
...
I want to know this as well!

I have found the following links somewhat helpful but still not what I
need
exactly

http://www.contextures.com/xlDataVal11.html
http://www.contextures.com/xlDataVal07.html

I basically want to do exactly as Nigel. A dropdownbox without
duplicates!
Its great because I can right click on the cell and go to 'pick from drop
down list..' and I actually get unique entries in a dropdownbox. Why cant
I
get this same thing in the regular dropdownbox without having to right
click?!

"Nigel" wrote:

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!