I import my transactions from my Internet Banking account as a *.csv file
and then open it with OOo Calc (currently ver 2.4 running under Windows XP
SP2)
The problem is that I keep my bookkeeping spreadsheets with the earliest
date at the top of the worksheet and the newest entry at the bottom, but the
online bank transaction list has the most recent at the top and the oldest
at the bottom.
No problems - I can sort according to the date column
This worked, except that transactions with the same date (for example you
could have several transactions on the 3rd March 2008) were not in the same
order as they appear on the bank list - let me explain with this example:
Bank List Sorted List
04/03/08 $50 02/03/08 $99
03/03/08 $80 03/03/08 $80
03/03/08 $20 03/03/08 $20
03/03/08 $60 03/03/08 $60
02/03/08 $99 04/03/08 $50
As you can see, the dates have sorted into reverse order but the amounts
have not, when the date is the same for each amount.
No problems, if I add another column and number the transactions 1,2,3,4,5,6
... etc, and then:
--- do a primary sort on Date, and
--- a secondary sort on transaction number
I can not only sort into DATE order, but also keep the transactions in BANK
sequence (which is important if you want the Balance shown on each line of
my spreadsheet to match the corresponding line balance on the Bank
transaction list).
All of the above works - SO HERE IS THE REASON I AM POSTING:
If I download 100 transactions it is tedious to type into a spare column:
1
2
3
4
5
6
7
...
...
99
100
So, I used a formula where Cell C76 contained a "1"
C77=C76+1 .... and copied this formula so
C78=C77+1
C79=C78+1
...
etc
Then I sorted first by the DATE column and then by Column C, but I found
that formulas do not sort in exactly the same way as integer numbers, so I
have gone back to typing: 1,2,3,4,5,6,7 ... 99,100!
Any suggestions or advice o how to simplifiy and expedite this sorting
process?
Many thanks, James
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
