How do I seperate invoices that have certain content?

[EnigmaMatter]

Hello,

I have a data set that is exported from QuickBooks -- it contains every line item of every invoice ever issued.

Let's say I sell Type A Products, Type B Products, and Type C Products. I often sell Type A, B, C and products together, and I often sell just one type on one invoice.

How would I seperate and view (using a PivotTable, Macro, etc.) just invoices with a certain type (and only that type of products)?

For example, I want to see all invoices that have JUST Type A products on it, and nothing else.

Thanks in advance for all of your help.

[BadlySpelledBuoy]

Attach some example data and you will get a useful response far quicker.

We have no idea what your data layout is like so have little context around your post above. That doesn't make it easy to provide a solution.

BSB.

[EnigmaMatter]

I can't really do that.

Essentially, the worksheet has evert single line item (i.e. each product purchased) in one column, and the invoice number in the second column.

I know that if I used a PivotTable, I can see ALL items purchased on an invoice by invoice number. What I am wondering is if I can see ONLY invoices that have ONLY a certain product purchased on it.

[EnigmaMatter]

I will try again, to see if I cask the question better.