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