Forum Discussion
Help creating an excel report
Hi all, I would appreciate someone being able to give me some guidance as to build the report how best I need. In the attached spreadsheet I have a set of data that I want to be able to filter ba...
Hi, thanks for the quick response. I can see the output but can't see any filter formulas, were there meant to be formulas in the sheet?
robwill100 The link explains how it all works. There are no filter formulas, though. The filter criteria are inserted in the section that I inserted above the raw data. A bit peculiar way of entering them, but that's how it works.
Change the criteria, press Advanced Filter again and Excel will have remembered the data and criteria ranges. Don't forget to select "Copy to another location" again.
If you insist on using an all in one formula, you could try this:
=VSTACK(FILTER(All_Funded,(All_Funded[State]="VIC")*(All_Funded[Supplier Name]="Test ABC")*(All_Funded[Equipment Type]="Telco")),FILTER(All_Funded,(All_Funded[State]="VIC")*(All_Funded[Supplier Name]="Test ABC")*(All_Funded[Equipment Type]="Solar")))It's a monster and can probably be improved. but I can't think of a way right now.