Conditional links

[CNA48]

I need to creat a shipping list from an order list

order list
column a1:a25-- furniture items
next to some of these furniture items is a column with an "x" or ""

on my shipping list I would like to list all the items from column a1:a25 that have an "x" next to them. I can create the formula for 1 cell but I can not figure out how to list all the items.

thanks in adavance for your help,

Candy

[CNA48]

Do I need more information listed so someone can help?

[Max]

Try the response to your later post in .worksheet.functions
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--