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
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