Hello Everyone,
I am working on a data set, for financial analysis, where I have various expense categories and months. In the attached example, I want to input the month and the category I need, then have it spill the data (explanation is in row 59)
I tried experimenting with Xlookups and the filter formula, but the examples I researched normally have the inputs neatly organized in one row. My two inputs are in both a row (B2-B52) and a column (F1-J1). Is it possible to spill a data set using criteria that is in both a row and a column?
Thanks in advance.
Bookmarks