Forum Discussion
blastlast
Feb 09, 2020Copper Contributor
Combining multiple ranges with filter-formula?
Hi! In Google Spreadsheets you can combine multiple ranges with the filter function with the use of { } as shown below. Is there any way of doing this with the new Filter-formula in Excel? Th...
Kimuyam
Nov 16, 2022Copper Contributor
PeterBartholomew1 You can use VSTACK formula in excel 365 to combine
PeterBartholomew1
Nov 17, 2022Silver Contributor
True, by the time one has VSTACK, HSTACK, CHOOSECOLS, TOCOL and WRAPCOLS, most things are possible, even if the notation is not as concise.