Forum Discussion
Using FILTER function and VSTACK function together
Hi, I am trying to use FILTER function and VSTACK function together to find out how many products that different companies sell and list them by the full text... Please help!! Peter
But there are 10-15 more sheets in my Excel workbook, so I am wondering how to filter without combining the sheets..
I have used a 3D range to group the various data tables. That requires the tables to be identically positioned on each sheet. Other options are available but require lists of source data to be maintained.
= LET(
consolidatedList, TOCOL(productLists, 1),
FILTER(
consolidatedList,
ISNUMBER(SEARCH(selectedCompany, consolidatedList))
)
)
The defined name "productLists" refers to the 3D range
=Products:Clearance!$A$2:$A$21- The reason I wanted to not consolidate the data into one sheet is because this is not the actual workbook... The actual workbook has 10-15 sheets and a few sheets have about 65 lines of unique data, some sheets have 40 lines of unique data, some have only 15 lines of unique data...
Also, I would like to protect these worksheets, so none of the information in them is changed..
PeterThe size of the 3D range needs to be sufficient to encompass the largest table. Other than that, I see no problems. The combined list can be held in memory without difficulty.
- Ok. Will you please show me how to do it?
I literally do not know what I am doing...