R
Robert Gillard
I have 2 worksheets no1 is a continuous row after row of monthly listings
i.e. date, amount, no of items from 1999 to date.
Worksheet no2 just shows the last 13 months.
I would like a formula to go in worksheet 2 so it will automatically update
its self after the current months figures have been added to the bottom of
worksheet no1.
I was told =offset(a1,count(a;a)-1,0) would give me the last item in a row
less 1, but have not been able to get it to work successfully,
Any other suggestions gratefully received.
Bob
Sorry originally posted this to programming board by mistake - not cross
posting
i.e. date, amount, no of items from 1999 to date.
Worksheet no2 just shows the last 13 months.
I would like a formula to go in worksheet 2 so it will automatically update
its self after the current months figures have been added to the bottom of
worksheet no1.
I was told =offset(a1,count(a;a)-1,0) would give me the last item in a row
less 1, but have not been able to get it to work successfully,
Any other suggestions gratefully received.
Bob
Sorry originally posted this to programming board by mistake - not cross
posting