Hi all:

I have been given a spreadsheet with over 1200 records in it. Within this spreadsheet is detailed records for several invoices (many:many relationships). There is a column that identifies the invoice number, and a column that identifies the type of purchase (class). Within class are several categories. I need to filter out all records except those invoices that contain a particular class. If that invoice is kept, I need to see all the expenditures for that invoice except the class that reads "Total" and "tax". Everything that I do will show me just the records for one class. How can I do this?

Thanks for any help.

Kim