Prev Previous Post   Next Post Next
  #1   Report Post  
tjkyon
 
Posts: n/a
Default rolling months

Hi, I'm trying to get excel to count the last 12 months of data in a
particular row for multiple years. The data in the rows are not numeric
values, but text values. Basically, on a monthly basis, I want the sheet to
get rid of the oldest month and include the newest month (currently, i want
the sheet to drop jan '04 and add jan '05).....

any thoughts?

thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate EDATE using days not months? pshift Excel Discussion (Misc queries) 4 April 21st 23 09:02 AM
How do I create a range of months in Excel? Mo Excel Discussion (Misc queries) 5 December 14th 04 06:05 PM
Calculate months and years Ned Ludd Excel Discussion (Misc queries) 5 December 10th 04 01:57 PM
how to calculate total months from month/year patti Excel Discussion (Misc queries) 1 December 8th 04 09:50 PM
How do I display months and years between two dates JSmith Excel Discussion (Misc queries) 1 November 30th 04 04:41 PM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"