One last comment:
You don't need to use Ctrl+Shift+Enter to commit that formula...it's not an
array formula. :\

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ron Coderre" wrote:

> Sorry for the confusion.
> Yes!...the Sheet3 references should be Sheet1
> (I just gave myself a newspaper over the snout for forgetting to correct
> that before posting)
>
> So...on sheet2
>
> A1:
> =IF(COUNTA(Sheet1!$B$1:$B$20)<ROW(),"",INDEX(Sheet1!$A$1:$A$20,SUMPRODUCT(SMALL(ROW(Sheet1!$B$1:$B$20)+(Sheet1!$B$1:$B$20="")*10^10,ROW()))))
>
> (Remember to Ctrl+Shift+Enter that array formula)
>
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "JerryS" wrote:
>
> > I'm a little thrown off. Do you mean Sheet1 where you list Sheet3? I'm not
> > getting any values. Thanks
> > --
> > JerryS
> >
> >
> > "JerryS" wrote:
> >
> > > I have a spreadsheet that lists all of our products individually in the first
> > > column. The next column is for selecting the items wanted. I'd like on a
> > > seperate worksheet to build a list of only those items selected. Is this
> > > possible?
> > > --
> > > JerryS