You can count the number of values in a single cell in Excel and Google Sheets that are seperated by comma using this function or formula.

Google Sheets has a built-in MATCH function, which you can use to search for anything in a defined cell range. The formula's syntax is =MATCH (key, range, type).