Calcuate Totals
 

I am using excel 2007. I have a spreadsheet that has the following data:

Acct No Date PPT Paid Sales Tx Total

300389124 4/19/09 60.46 4.54 65.00
300389124 4/19/09 32.55 2.45 35.00
300389124 4/19/09 65.00 0 65.00
300389124 4/19/09 35.00 0 35.00

(PPT Paid + Sales Tax = Total amount). I need to only see the total records
with the paid and sales tax amounts if they are present. I can't exclude all
records with 0 sales tax because there are other records that have no sales
tax and are valid. I need to check for the above situation when it occurs and
would like to see just the first 2 records not all 4 records. I have tried
the remove duplicates on the menu bar, it helps out for some but not in every
case.

Hope this makes sense.

Thanks to all!!

--
Bruce