Ian (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
lovingboth) wrote2005-07-14 12:38 pm
lovingboth) wrote2005-07-14 12:38 pm
Without googling it...
In Excel, how do you count the number of times a particular string appears in a range of cells?
You're allowed, nay encouraged, to use the "help" facility, including the ever helpful paperclip.
(Oh, using your finger and going 'one, two, three..' doesn't count! :) I'm looking for a formula.)
It must be a fairly frequent need and I'm curious as to how many people know or can use the "help" to find out. When I get home, I'll see if the lovely OpenOffice is any better.
You're allowed, nay encouraged, to use the "help" facility, including the ever helpful paperclip.
(Oh, using your finger and going 'one, two, three..' doesn't count! :) I'm looking for a formula.)
It must be a fairly frequent need and I'm curious as to how many people know or can use the "help" to find out. When I get home, I'll see if the lovely OpenOffice is any better.