So read Valentine Schelstraete ‘How to use the FILTER function in Google Sheets’ article. I’ve also read other articles on using the FILTER function in excel.
I’ve tried variations of the FILTER function and cannot get it to work without an error. I’ve been through all the errors and solutions but still it doesn’t function.
I’m trying to figure out if it might be browser based functionality or if it is user error (likely)?
Here’s a screen shot of the google sheet and error. I’ve tried lots of variations with just a fixed filter region, unlimited rows, etc. Still get the same error. I initially had the data on another sheet so copied the data over and still got the same error.
Kind of lost since the error is very generic with multiple reasons resulting in the same error.