Forum Discussion
Filter Function Dynamic Arrays
Dear All I have one question for all of you, is there any possible condition in filter function in multiple ranges or with nested formula use of filter function.................... Q.: I want to us...
Ashutosh_Dwivedi The formula you provided doesn't make much sense (to me at least). Perhaps you are trying to spill matching cells from both ranges like this:
=FILTER((Sheet1!A1:A40),(Sheet1!A1:A40)=(Sheet2!A1:A40),"")
If not, perhaps better to upload a file with data in it, explaining what your intend to achieve with the formula.
Riny_van_Eekelen Thanyou for reply
Here file is attached for your references.
Ashutosh_Dwivedi Sorry. Don't understand your intentions. Do you perhaps want to append the two lists in DATA1 and DATA2? FILTER is used to extract data from a range (preferably a structured table) based on one criterion or multiple criteria.
- Riny_van_Eekelen Dear sir
I want to first spill data1 after finish the data1 it will continue to data2 sheet. It's possible.You want to stack the two arrays?
https://exceluser.com/6534/how-to-stack-and-shelve-dynamic-arrays/
