I’m trying to filter using a single column table of about 30 names (headed “NAME”) as a search criterion, the idea being to retrieve all the rows from another large table where the “NAME” column contains one of those 30 names. Really a database operation, but calc can nearly do it…
It works OK with 8 names or fewer, but I’ve discovered there’s a limit of 8 rows to the criterion.
Can anyone suggest an alternative approach using calc?
Thanks,
Peter
Advanced filter supports up to 8 search criteria, if you want to filter data only by name, it would be just one criteria with multiple values in it. When you create table with criteria for advanced filtering it means that you can have up to 8 columns with test conditions (those are logically connected with AND operator), but you can fill each column with much more than 8 values (those are logically connected with OR operator) So just create one column for NAME filter and populate it with all the names you want to include in the result set. Nice idea is to Define range for the source data and for the filter result data, and Named range for Filter criteria - makes work easier 
Thanks for your reply. Unfortunately I don’t have the kudos to upvote it. I read in documentation that there was a limit of 8 criteria, but I thought this meant 8 rows, not columns, in the filter definition.
Ah - I was trying to do this in Open Office’s version of calc - where it really won’t accept more than 8 rows in the filter definition. If you have more than 8 it comes up with an error box.
It works with more than 8 in libre office - nice. Sorry to bother you with Open Office’s problems!
