Google "=Filter()" function excel equivalent.

Sadodare · #1 08-01-2016, 11:15 AM

Hello, I have a Google sheet that I need to convert to Excel due to Sheets not having a "Collapsible Group" function yet.
There is some functionality in this sheet set that contains what this reference document contains: https://docs.google.com/spreadsheets...it?usp=sharing

If the main sheet has items in the categories selected, the other sheets will display those items, which is the functionality I'm trying to convert to excel.
Any help is appreciated.

For reference, here is the Docs help on the command I'm looking to Excel Source: https://support.google.com/docs/answer/3093197?hl=en

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
=filter() feature of google sheets not in EXCEL	peter.threepins	Excel	1	07-13-2016 08:44 AM
Formula for filter "Incomplete Tasks for User..."	patrickd123	Project	1	04-07-2015 08:15 AM
"Open Recent" and "More..." in Excel and Word	BudVitoff	Office	0	04-03-2015 09:17 PM
How to "deactivate" the Excel's SAVE function	KIM SOLIS	Excel	1	11-05-2011 01:57 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM