Forum Discussion
Excel Not Recognizing Reference Pattern
Good morning! Looking to see what the best/easiest option is as I've been trying to use an offset and lookup formula to no avail. In columns A & B, I have a set of tables with dates by week ...
Without seeing your file I would recommend to re-design it as it sounds like you are capturing daily information and then added subtotals by week. Now you want to extract those sub-totals in consecutive rows.
Try this in D4 and copy down:
=INDEX(A:A,(ROW()-ROW($D$3))*9-2)However, much better to get rid of the sub-totals and use Excel's built-in functions to summarise the daily entries by week, month, quarter, year. Whatever. Share a file if you think it's feasible in your situation.
- That sounds like exactly what I'm trying to do, but my origination point was a bit off. I'm going to try to post the file here directly. Thank you!
