Oops, miss-read the latest "13" months (what was given earlier was for 12)
The Summary sheet should show the latest 13 months records
Try this slight tweak to the earlier formula ..
In sheet: Summary
Put in A1:
=OFFSET(INDIRECT("RawData!$A"&COUNTA(RawData!$A:$A )-12),ROWS($A$1:A1)-1,COLU
MNS($A$1:A1)-1)
Copy A1 across to J1, fill down to J13
A1:J13 will always return the last 13 rows of data
from sheet: RawData as new data is added there
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|