Forum Discussion
Need to write a formula to get data from another worksheet based on the date
HI , I need help to write a formula to get my worksheet done. there are two sheets in my worksheet "Day Production" and "Summary" I need to get all the information to the summary sheet which I e...
There's an issue with the way the workbook is arranged. To take advantage of dynamic arrays, the Summary sheet must not be pre-formatted as table (Tables are dynamic in nature and expand when data is entered in the immediate perimeter but the do not play well with spilling). Naturally, converting it to a range also takes a way slicers.
My solution utilizes FILTER to fetch records based on the input date.
=LET(
header, DayProduction[#Headers],
filtered, FILTER(DayProduction, DayProduction[Date] = Input, "None found"),
VSTACK(header, filtered)
)
