Filtering Data

[mgalloway]

I have a large spreadsheet that has 365 rows (one for each day) detailing sales activity (4 columns). I want to be able to filter and display the last 14 days of data, each of the 14 days being a separate row within my results. From the results of my filter, I will be developing a trend graph. The spreadsheet is manually updated each day. I want my filter to automatically adjust the "rolling" 14 days. Possible?

Thanks in advance.

mgalloway

 

[Andrew Poulsom]

Maybe you could try a dynamic chart:

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html#LastSoMany

 

[thomasbeard]

I assume the dates are included in your data (if not enter the first date at the top and drag down, they will increase a day for each cell). Then insert autofilter from the data menu/filter/autofilter and customise the date range to something like "greater than 16/12/05"

 

[mgalloway]

I probably was not clear enough on the results. I want to be able to produce a "rolling" 14 rows of data below the 365 rows. The "rolling" 14 rows will be the last 14 days of the sales data, dynamically changing each day.

Mike.