View Single Post
  #1   Report Post  
Max
 
Posts: n/a
Default

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