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

  • Failing as snow again, never wanted to..

    A tiny bit, but gosh, this will have been the snowiest winter in London for ages. The walk to school did help me wake up a bit (although I feel the…

  • One for Bad Science?

    Hmm, a Press Association story saying breastfeeding has almost no benefits to the baby has been picked up by the Mail and the Telegraph and... with…

  • Two recent stories

    I've forgotten to go 'hooray' here over this story from a couple of weeks ago: Food labels advice change over Palestinian territories. I am happy to…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 2 comments