Forum Discussion
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...
I don't use Google sheets so can you explain what you are trying to achieve and perhaps provide a sample spreadsheet?
Thanks for taking the time!
Here is a spreadsheet that shows the result I want. It's not just combining the two lists I'm after, I want to have a dynamic filter without any Index/match or Vlookup-workarounds.
https://docs.google.com/spreadsheets/d/1gbIy-06at_1PhTquwUSO5xfTah-PSB7-guC-XtoOWa0/edit?usp=sharing
