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
|