On Jun 28, 6:12*am, Mr X Z wrote:
Hi All
Hope all of you are having/have had a great day.
With sweltering weather outside I am stuck indoors analyzing banking
data.
I am hoping one of you could make life easier by suggesting that would
make things easier.
Okay I have many different bank statements on the one sheet sorted by
date.
What I am trying to do is check inter account movements.
These aren't obvious by the account "transfer" classifications the
banks use so I am having to examine *transactions on the same date of
which there could be as many as 10 to 15 and then similar amounts
coming/leaving the accounts.What I would like to achieve a sort of
banding depending on the date so it differentiates the different data.
I figured that maybe part of the solution might be to create a
"helper" column with the formula A1-A2, A2-A3 etc. This leaves me with
a zero and when there is a change in date negative figs then perhaps a
VB script to get the banding.
Maybe this isn't possible.
Thanks for looking.
Kind Regards
M