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
Thanks in advance.
mgalloway