[mso] Re: once more COUNTIF ?
- From: Jim <n1jmm@xxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Mon, 15 Sep 2003 22:54:49 -0400
I don't think countif is the correct method for what your trying to do.
Actually I dont think excel has a command/function to do that. However
the good news is it can be done in VB so I would guess it could be done
in excel using VBA.
CountIf is going to look for an EXACT match of your 'test' value with
the entire contents of the cell, not just a portion of the contents.
-Jim-
Robert Carneal wrote:
>One more time please, my head is spinning from the COUNTIF posts. I did not
>keep it straight.
>
>If A1 contains as text "1801-05-19", can I do this in Cell AA1?
>@countif(A1,"-")
>and get 2 as a result? (I don't think so, I think the correct usage for
>COUNTIF is:
>
>COUNTIF (A1:A6,"-") will tell me how many cells contain the "-", right?
>
>I am looking for a method to the number of occurances of a character in one
>cell. For example if I have "Mattie Lee Bell" in A1, and I want to count
>how many "e"s there are, COUNTIF will not do the job for me, or will it?
>
>Thank you.
>
>Robert
>
>
>*************************************************************
>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
>*************************************************************
>
>
>
*************************************************************
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:
