S
sokevin
Is there a function where i can find the moving balance?
For example
i have DR and CR.
i can do Balance = DR cell + Cr Cell + Previose Balance
BUT whenI DO A SORT on the data, the column that contains the balanc
formula will now not work
i attact link to pic of spreadsheet to explain things better
[image: http://member.telpacific.com.au/soke/general/msexcel1.jpg]
and after i sort the data....
[image: http://member.telpacific.com.au/soke/general/msexcel2.jpg
For example
i have DR and CR.
i can do Balance = DR cell + Cr Cell + Previose Balance
BUT whenI DO A SORT on the data, the column that contains the balanc
formula will now not work
i attact link to pic of spreadsheet to explain things better
[image: http://member.telpacific.com.au/soke/general/msexcel1.jpg]
and after i sort the data....
[image: http://member.telpacific.com.au/soke/general/msexcel2.jpg