In column A i have some accts that should have 0 Balances. How can I automate and go through and identify these accounts (0324, 0311,4024, etc.) and then change the "amount" column (column E) to the number 0. There are 5000 lines in this sheet.
Feb 21 2007, 04:55 PM
I would write the following in the column next to your data.
If(or(acc=0324, acc=0311, acc=4024),0,Amount)
Then paste as values and delete the old column.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.