Filter using Match and Search? Filter with multiple conditions HELP!

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen

Thank you I have attached a clear example

Unfortunately I dont think that's what I need. On your example it doesn't find partials and I also can't replicate the formulae on the version of Excel for web i'm using?

Is there a way to combine Match and Search functions do you know?

F2=filter(a3:c6,(b3:b6>=b10)*(isnumber(search(c10,c3:c6)))+(isnumber(search(c11,c3:c6))))

thats perfect!!! is there anyway to make those isnumber(search formulaes just 1 big formulae that accounts for both c10 and c11 (as there could be many), instead of simply doing +isnumber(search etc?

also, using that formulae, if you have nothing in the category search bar, it comes up with everything. the same is if there is a search term in c11 but nothing in c12, it comes up with everything too. It's almost as if it's saying "if there's nothing in here, we'll ignore the search and filter on everything"

just that you might be looking for funders which could encompass different things. e.g. a new hospital ward project, i would maybe search for categories of "health" as well as "building" to try and find funders who fund one, or both, of these types of projects. I suspect the list won't be any longer than 5 'categories' they could search for at any given time so the formulae adaptation could be an extension of the above, but it needs to work where it doesn't include any blank cells.

so for example, the formulae above needs to have the AND/OR functions nested somehow, where the first one of >= is ALWAYS present, and then follows multiple ORs of the SEARCH( formulaes.

eg. FILTER( range, >=search cell) AND ANY OR ALL OF THE FOLLOWING (search xxxx

I realise I might not be making sense in my confusion so i've put some context if that helps!

You are looking for potential funders for a charity who want to build a new childrens hospital ward in the UK.

To do this, you would go into this excel 'database' and first put in the lowest grant size you'd want e.g. 5000.

Next, you want to filter all the potential funders by the category, which means the sort of work they could fund, to rule out completely irrelevant ones e.g. funders who ONLY fund work in Uganda.

To do this, you might start searching on categories like "Health" or you might then try "Health" and "building".

Doing so would bring up any funders who's lowest grant size is 5000 or above, that ALSO have a category of "health", of "building" or fund both "health" and "building" work.

total flexibility as it's creating this from scratch so i'm open to any and all suggestions! the key thing is being able to search for multiple potential terms at once. kind of like your brain dump of "hmm what kind of funders might be interested in this" thank you for your help!

that formulae is EXACTLY what i needed thank you so so much!! and the multi-select table is something i didn't even know you could do in excel!! can't thank you enough!

yes the slicer is super intuitive and a great addition very helpful

I'll take away to the team and get cracking! In hindsight I'll probably need to add to this to also include location as a searchable column, in the same way the categories work i.e. i type in a list of options like UK, US, Global and filters on that too

just done that thank you

I may be back in the new year with help on the brackets to add in an additional search function! haha