Forum Discussion
Ashutosh_Dwivedi
Oct 05, 2021Copper Contributor
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 use multiple range in different sheets in filter function i.e. =filter((sheet1!a1:a40, sheet2!a1:a40), (sheet!a1:a40)*(sheet2!a1:a40),""). But final result is #N/A, How can i solve it.
Q2.: Formula should be spill.
- Marto_KCopper Contributor
- Riny_van_EekelenPlatinum Contributor
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.
- Ashutosh_DwivediCopper Contributor
- Riny_van_EekelenPlatinum Contributor
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.