To count the frequency of a text in Excel, you can use the Countif function ... write all the names in a separate column. You can do this manually. However, if the data is large, doing this ...