Forum Discussion
Help creating an excel report
robwill100 You could use Advanced Filter for that. See attached file and read more about the feature in the link below.
https://www.howtogeek.com/848055/how-to-use-advanced-filter-in-excel/
- 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.
Did you read the blog Riny_van_Eekelen mentioned. No formulae are here. You setup criteria configuration and click on Advanced icon.
