Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=IF(AND(OR statement needed? | Excel Worksheet Functions | |||
Another IF statement needed | Excel Worksheet Functions | |||
IF STATEMENT HELP NEEDED!!! | Excel Discussion (Misc queries) | |||
much needed If/or statement help | Excel Discussion (Misc queries) | |||
If statement help needed please | Excel Discussion (Misc queries) |