To count the frequency of a text in Excel, you can use ... you can use the Unique function. The Unique function creates a list of unique values from the selected range of cells.

Excel's COUNT function produces a number of cells containing any value, but only COUNTIF and COUNTIFS can use conditions to ...