Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Do you really mean to count the items, or sum the amounts (albeit they are
in text form)? Can you give us some sample data. -- HTH RP (remove nothere from the email address if mailing direct) "tjkyon" wrote in message ... 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 |
#3
|
|||
|
|||
thanks for the reply.
top rows consists of the months from Jan '04 to Jan'05 Jan Feb March ...... the columns are individual codes, such as Watch 100ct Batteries 200ct and so on an so forth and within this grid, there are reason codes that gets put in, such as For Jan '04, Watch 100ct - Low inventory For Jan '05 Batteries 200ct - Consumption too high....etc for my january 2005 update, I want the sheet to count the number of times there's text within that grid for only the latest 12 months (feb '04 to Jan'05) hopefully this has helped you in helping me. Thank you "Bob Phillips" wrote: Do you really mean to count the items, or sum the amounts (albeit they are in text form)? Can you give us some sample data. -- HTH RP (remove nothere from the email address if mailing direct) "tjkyon" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
How do I create a range of months in Excel? | Excel Discussion (Misc queries) | |||
Calculate months and years | Excel Discussion (Misc queries) | |||
how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |