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.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.