Oct-27-2016, 09:52 AM
I'm still trying to do it using python.
Headings are:
A/C Code, Account Description, Old A/C Code, O/B Debit, O/B Credit, Current Month Debit, Current Month Credit, C/B Debit, C/B Credit
I can tabulate Last 7 variables using excel formula.
Form the right I count to number of cells contain values, if it is one took vales to last variable, if it two values taken to second from last, like did up to "old A/C code"(ie 7 from last variable)
And then copy the formula to other cells.
Like to do this using python, I have to learn more on this.
Headings are:
A/C Code, Account Description, Old A/C Code, O/B Debit, O/B Credit, Current Month Debit, Current Month Credit, C/B Debit, C/B Credit
I can tabulate Last 7 variables using excel formula.
Form the right I count to number of cells contain values, if it is one took vales to last variable, if it two values taken to second from last, like did up to "old A/C code"(ie 7 from last variable)
And then copy the formula to other cells.
Like to do this using python, I have to learn more on this.