View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bruce D. Bruce D. is offline
external usenet poster
 
Posts: 14
Default IF statement help needed

I am using excel 2007. I have a spreadsheet that contains data:

Acct no Date PPT Paid Sales Tax Amount

1000 4/30/10 60.46 4.54 65.00
1000 4/30/10 32.55 2.45 35.00
1000 4/30/10 65.00 0 65.00
1000 4/30/10 35.00 0 35.00

(PPT Paid + Sales Tax = Amount). I want to exclude the last 2 records. I
can't use sales tax 0 because I have other records that may have no sales
tax but are still valid. I have tried the delete duplicates on the menu bar
and it helps for some records but not all cases. Eventually I want to add a
subtotal to the account number once the dupes are gone. The dates will vary
for when each account was paid. Any ideas??

Thanks everyone!!
Bruce