Find the Frequency of Text in the Sheet

Want to count how many times does a particular text appear in your sheet?

1)Select the cell where the text is located

2)Press Ctrl + C (Copy) and then leave C and press F (Find) and then leave F and press V (Paste) - Do all this while Ctrl is pressed

3)Click on the 'Find All' button and you can see the number of times the text appears in your sheet

Easily Excel at finding and counting