Forum Discussion
Filtering non-numeric data
If your data used a separate column for each language of interest, this would be a trivial issue—you could use Excel's Auto Filter capabilities.
But let's assume that you want to use a delimited list of language identifiers (names or codes or tags). In the attached workbook, I use comma-delimited lists of the ISO 639 language codes, but the solution is the same for essentially any language identifiers; they can be of variable length, but cannot be case-sensitive or include commas or whatever delimiter you choose.
See the attached workbook. Note that my language support lists are neither complete nor necessarily accurate.
Comic Sans and Helvetica walk into a bar, and ask for drinks. The bartender glares at them and says, "We don't serve your type in here."