[mso] Re: excel 2000 word count
- From: "Pam" <ltf01@xxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 26 Jul 2003 11:04:55 -0500
Hi Ray,
This would be great except I won't know what I want to count. What I have
is a list of search terms used. I would like to tally these up into usable
statistics/data to tell me what terms are being searched for most often and
least, for example.
Thanks,
Pam
>
>Pam,
>
>One easy way to do this would be to use the COUNTIF function with
>wildcards. Let's say that the text you wanted to find was 'like' and you
>wanted it to hit on each of the following:
>
>-like
>-Like
>-LIKE
>-I like a challenge
>-we are both alike
>
>What you would do is enter the following formula in any cell which is
>NOT in Sheet1:
>
>=COUNTIF(Sheet1!$1:$65536,"*like*")
>
>This looks at every possible row in the sheet and checks for the text
>'like' on a case-insensitive basis anywhere in each cell. If you are
>only going to be using a smaller range within the sheet, you can
>obviously reduce the size of the range checked. The asterisk at the
>beginning allows for any text to precede the 'like' and the one at the
>end allows for any text to follow it.
>
>There's only one real drawback I can see with this, which is that if
>there is a cell containing the target text more than once, the function
>will only count it once. To put it another way, it reports the number of
>cells which contain the target text, not the number of times the target
>text occurs, of you see what I mean.
>
>If this is a problem, let us know and we'll all put our thinking caps
>on!
>
>Ray Blake
>
>Is there a way to count the instances of individual words and phrases on
>a
>single sheet of a workbook? If it can do this can it print out the
>results?
>
>Thanks,
>Pam
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
