Buttons to push...?

Hello,
I'd like to filter/manipulate sales data to identify customers who purchased from a particulcar group of products but NO other product groups. These are my field names:

InName ILProductGroupNumber ILProductNumber ILDescription ILOrderedQty ILInvoicedQty ILTotalAmount InDate Period FY PGNumber PGDescription InInvoiceNumber InInvoiceType
Kiat

Hi,

You should be able to do this with autofilter.

Highlight your data range

Go to Data > Filter > Autofilter

Even with autofilter...I don't see how I can end up with a list of customers or invoice numbers that don't contain a given product group. I would have to be able to filter multiple data ranges at once, i think... that is for all invoices, I need to id customers who bought a given part numbers/or groups and no other products.