Hi,
I was wondering if anyone can help. I want a filter sort out table on one sheet to a breakdown on another sheet.
To explain, I have two sheets. Sheet1 is Archived Reports. Sheet2 is a "Dynamic" Calendar. I need both of them to somehow connect in a very specific way. On Sheet2, I need to show on Invoice Numbers Column from a specific date range. On Sheet2, I currently have =FILTER(Table2[Invoice '#],(Table2[Machine Number]=H5)*(Table2[Date]=O8),"Not Found") on B16, it works for just one date which is cell O8, but I need it to show the invoice number for multiple dates.
I'm not sure what formula to use to achieve that.
Thanks for the help.
John S.
I was wondering if anyone can help. I want a filter sort out table on one sheet to a breakdown on another sheet.
To explain, I have two sheets. Sheet1 is Archived Reports. Sheet2 is a "Dynamic" Calendar. I need both of them to somehow connect in a very specific way. On Sheet2, I need to show on Invoice Numbers Column from a specific date range. On Sheet2, I currently have =FILTER(Table2[Invoice '#],(Table2[Machine Number]=H5)*(Table2[Date]=O8),"Not Found") on B16, it works for just one date which is cell O8, but I need it to show the invoice number for multiple dates.
I'm not sure what formula to use to achieve that.
Thanks for the help.
John S.