... and thanks...

Grant Fritchey (9/1/2015)

---

DuncEduardo (9/1/2015)

---

Hi Grant,

Many thanks for replying. Yes, I had noticed Mike on LinkedIn already but was unable to mail with the account level I currently have; I'd have...

so many thanks for this, much appreciated

... and then I remembered the syntax for "LAG" which is also very useful for this I think

Many thanks

ChrisM@Work (8/23/2016)

---

Sure no problem.

Can you set up...

in the past, I'd have used embedded SQL, a variable, and WHILE construct but seems bit overkill for this.

bit rusty with Windows functions

yes, if you don't mind. I'm doing a few other things and had to put this aside.

I wouldn't say it's completely a "running total" problem as you require only previous 12 records from the one in scope.

Running Total will keep adding next value but not select...

namakakiweyho (10/22/2011)

---

I just spent a whole weekend on this problem. My CSV file contains text data contained within double quotes, eg "blah",1,1/10/2011,"blah" and numeric and date data. All fields are...

Thanks to everyone so far for their innovative solutions; I thought it might trigger quite a bit of interest.

REF123 (3/30/2010)

---

Thanks, Luke. I didn't realize that numbers in the beginning of the column names were contributing to the problem.

Unfortunately, I have requirements to keep/show the column names as is....

Yes but you've explicitly stated numbers corresponding to calendar months from Jan - Nov. I try to avoid any form of "hard-coding".

Nice solution though

I've used mixture of "while", "getdate()", "datediff" and for the minute size of it, works well.

I'd consider tally table for something more substantial, but for the sake of 12 rows...

Tally Table seemed unnecessarily complex - am sure there's something simpler

so an intriguing update.

I created a new Excel 2007 file, and just copied in some data into 3 tabs and changed package to point to this new source.

Now, the error...