Software

Ask something
Question Locked

Microsoft Excel Specific Data Count

0 helpful
2 replies

by beany02 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a formula, or way to count specific data, for example, the word 'hello' could be on a spreadsheet numerous times, is there a way to count the word 'hello' and bring back results like there is 21 on this spreadsheet ect.

Thanks

2 replies

by purpleskys

find and select option...type in the word you're searching for, click find all, it will list them all and show a cell count in the bottom left of the search box
edit: there could be other ways, that just seemed like the easiest that i could find

This discussion is closed to new replies.