Re: dynamic list to remove duplicates and spaces ?

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 09:47:05 -0400

To do what you want, you would need to use complex formulas to build you
list of unique, alphabatized names and then probably a defined name to pick
up that new list.

I assume you can figure out how to do that. 

-- 
Regards,
Tom Ogilvy
"Keith" <keithr@gmail.com> wrote in message
news:9a18c300.0406180521.503b3040@posting.google.com...
> Hi,
>
> I have a drop-down box I'd like to fill with unique, alphabetized
> names sourced from another ***.  However, the list of names on the
> other *** contains duplicate name entries and varies in length as
> the list is updated.
>
> Currently I reference the entire column that contains the names, which
> results in duplicate entries, and many many spaces.
>
> Is there a way to dynamically reference this list so that the
> drop-down doesn't have any duplicates or spaces?  Preferably I'd like
> to do this in the ListFillRange property of the combobox, and without
> any VB code.
>
> Thanks,
>
> Keith