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 ...
I may need to see a sample sheet but this is the idea.
Dates being Col A:
=LET(wrapped, WRAPROWS(dates, 9, 0), TAKE(wrapped, , 1))
This one didn't quite work I believe due to not trying to pull the dates themselves, but rather a text value of "Week Total (Sat, Dec 9 - Fri, Dec, 15)" that is in the Total Row of a table with the dates themselves. I'm trying to pull the text from the total row and the summed value into consecutive rows in columns D & E through references versus having to manually assign the references or copy paste the text. However, I'm going to try to post a sample, but it may be difficult. Thank you!