As a worksheet function the FIND function can be entered as part of a formula in a cell of a worksheet. With the COUNTIF function Excel can count the number of times a word or number appears in any range of cells. Within_text required argument The text string that we need to search.
To search across the whole worksheet click on any of the cells on.
Start_num is optional and defaults to 1. The search is case-sensitive. With your excel sheet opened navigate to the Home tab Find Select Go To Special. Instead of manually counting how often a certain value or number appears let Excel do the work for you.