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...
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/
- Detlef_Lewin
Dear Sir
Exactly i want the same for two array apend with the arrays stacked one on top and second on bottom after finish the first data.
And please send if you have file uses this formula.: "=LET(name1, name_value1, [name2, name_value2], […, …], named_result)"
Ashutosh_Dwivedi Unless I'm mistaken, that's not possible with a formula. You could use PowerQuery. See attached.
- Dear Mr. Riny_van_Eekelen
Thanks for giving the time to solve our query, but this is not my solution which I'm expecting all of you, In result sheet you must remove the "NO" in power query calculation.
Thankyou so much.
