There's still an issue, when it comes to querying or filtering data - while filtering it is considering all the individual data points as a single data point which defeats the whole point of multiple selection
I've got it figured out for filtering, but you may be right with the querying...i'm not sure how to fix that one. It's because it's storing the cells in a comma-separated array. But to get it working with filter, you can do this: =FILTER(Table1[Fav Color],SEARCH(L1,Table1[Fav Color])) where L1 holds the color you're searching for. It'll then filter for every row that contains that color
![Microsoft Excel vs Google Sheets Tables [NEW for 2024]](http://i.ytimg.com/vi/vBp5mveYZZ4/mqdefault.jpg)
Thanks Eamonn!!!
You’re welcome!
There's still an issue, when it comes to querying or filtering data - while filtering it is considering all the individual data points as a single data point which defeats the whole point of multiple selection
I've got it figured out for filtering, but you may be right with the querying...i'm not sure how to fix that one. It's because it's storing the cells in a comma-separated array. But to get it working with filter, you can do this: =FILTER(Table1[Fav Color],SEARCH(L1,Table1[Fav Color]))
where L1 holds the color you're searching for. It'll then filter for every row that contains that color
Great video!
Thanks!