What function would I use?

[Capn_Chord]

I am making a spreadsheet for my work. In this
spreadsheet I enter data such as the name of a customer,
additional products they may have purchased, and the
price paid for the additional product.

I have to list all customers on this sheet wether or not
they bought any of the additional products. Then I have
to do a second sheet only for those who bought the
additional products. Is there someway to make the spread
sheet go through itself and pick out those who bought the
additional products and then transpose those onto the
second sheet.

Thank you in advance for any help that you can offer.

 

[Jay]

I have to list all customers on this sheet wether or not

they bought any of the additional products. Then I have
to do a second sheet only for those who bought the
additional products. Is there someway to make the spread
sheet go through itself and pick out those who bought the
additional products and then transpose those onto the
second sheet.

At first, I thought of a pivot table, but there's an easier way.

On the first sheet, list the customers in column A and put "Yes" or "No" in
column B.

On the second sheet, put
In A1: =IF(Sheet1!A1="","", Sheet1!A1)
In B1: =IF(Sheet1!B1="","", Sheet1!B1)
and then extend these two downward for as many rows as you need.

On the second sheet, select column B and use
Data > Filter > Autofilter
This gives you a pull-down control at the top that lets you display only
the Yes's. You can hide column B on the second sheet if it's too much
clutter.

Adapt the details to your situation.

 

[Capn_Chord]

Thanks for the suggestion it did work really well, but I
think I'm dealing with a little too much data for it.

This is an example of what I'm trying to do.

<pre>
Product 1
--------------------------------------------------------
Customer name | accesorie a |accesorie b| accessorie c |
--------------------------------------------------------
Bob | yes | | |
--------------------------------------------------------
Mary | | yes | |
--------------------------------------------------------
John | | | yes |
--------------------------------------------------------
</pre>

This is a very small example of the worksheet where I do
the data entry. I hav seven worksheets like this one.
Basically I have seven major products that people
purchase and they purchase accessories a,b,or c along
with those. I need for this to search through the seven
worksheets and pick out only the people who bought
accessorie A and put them in a list by themselves like a
report. In theory it should group everyone who bought A
together in one list and everyone who bought b and so
forth. Then this should all print out on one sheet.

Thanks again for any help that can be given.

 

[CLR]

I would reccommend setting all your data up in one database on one sheet,
and then use AutoFilter to generate the reports you want.......

Vaya con Dios,
Chuck, CABGx3