Re: select from a fragmented list

From: AndrewB (AndrewB_at_discussions.microsoft.com)
Date: 12/02/04 

Date: Thu, 2 Dec 2004 14:49:02 -0800

Hi Frank,
Thanks, but it didn't quite work out.
There are normally 15 rows between each site name. ie sites names are found
in rows 1,17,33,49,63... and the list is frequently extended.

Is there a way to extract the site names only to a new, contiguous, list?

"Frank Kabel" wrote:

> Hi
> i would create a separate list. e.g. enter the following in B1
> =OFFSET($A$1,(ROW()-1)*2,0)
> and copy this down
> Now use column B as source for your data validation list
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> "AndrewB" <AndrewB@discussions.microsoft.com> schrieb im Newsbeitrag
> news:ED69FAB2-1CDC-4EE6-93AB-DE4FFDD789FC@microsoft.com...
> > how to I limit the data in a drop down list?
> > ie.
> > column A has a list of site names, interspersed with month names.
> > eg. a1 = "Agnew Bros", a2= "Jan", a3="Feb",a4= "Opunake", etc
> >
> > I've been using a data validation list to pick from, but get all the
> month
> > names listed in the pick list.
> >
> > How do list only the site names in the pick list?
>
>