I was hoping that someone can help me in writing array formulas in excel that would return pricing from "Last Ordered" and the "Date of price changed" from a list of invoices.
Below would be the example of the information that I need from the data table. Please help.
Item#...