Forum Discussion
Help with formula in Exc
I have a spreadsheet with multiple tabs at the bottom. On the Master I have one column with drop down list. I want the info on the master tab to feed over to the tab corresponding to the tab that m...
I copied your formula into my spreadsheet and it says That function isn't valid - it is highlighting the word FILTER.
Yes sounds like a problem with the Excel version. I'm guessing you are using something older than Excel 2019.
Other alternatives include pivot tables and power pivot and some much more complicated formulas that I would avoid. Attached I included an example of a pivot table. There are many ways to configure and format the pivot table but I'll leave that up to your discretion.
Also I want to point out that I formatted the original table as a Table (but you could also just turn Filters On) and now you can easily use the drop down triangles to Filter the data based on the Type column and you don't need all the other tabs.