Search Professionals by Specialties

Hi!! I'm working on an Excel sheet to effectively search through a list of professionals and their specialties. All information in linked screenshot is just a placeholder. If you have any questions I'd be glad to answer!!

Currently, I have each professional in their own row.

First name, Last name, List of specialties, Split

"Split" is the start of a textsplit function, splitting the list cell into individual specialties across the row.

I originally tried this by creating a function that vertically lists all unique specialties underneath the data set, then using that list as the data validation lists for the options. I also made a "score" column that adds points to each professional depending on how many times options are in their specialties, then another function to list and sort anyone with a score higher than (highest score)-2.

The problem with this is that once the specialties reach a certain number, the grand list of specialties only returns #CALC! because it is too long.

https://imgur.com/a/QoQvvmK