I have a data series which consists of daily data in one worksheet in Excel 2010.
I also have an array (because of some matrix multiplication) in it, and I cannot create a table with an array in it, so I can't really use vlookup (or can I? Someone please enlighten me).
I need to retrieve data every 7 days for some testing from this particular column in the first sheet.
How do I use vlookup (or something similar) to get the data every 7 days into another worksheet beside it? I have the dates as the first column.