Ian (lovingboth) wrote,
Ian
lovingboth

  • Mood:

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.
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 2 comments