[mso] Re: once more COUNTIF ?
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 16 Sep 2003 17:40:02 -0400
Yep..I knew it would be one of them killer text function combos...that's why
I said look in there...but, I'll be danged if I really understand them,
Robert...I usually just waste hours using them in different combos til I get
what I want
And that's what I would have done for you last nite, cept I was pooped LOL
Did you figure this out yourself or did someone like Ray send this to the
group and I'm missing posts?
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Robert Carneal
Sent: Tuesday, September 16, 2003 3:03 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: once more COUNTIF ?
If I have Mattie Lee Belle in A1, and =LEN(A1)-LEN(SUBSTITUTE(A1,"e",""))
in A2, then the result is 5.
If I have "1808-09-12" in A3, and =LEN(A3)-LEN(SUBSTITUTE(A1,"-","")) in A4,
it shows a result of 2.
This IS giving me what I want, but I am a little pleasantly surprised- I
thought SUBSTITUTE replaced a character for a character?
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
*************************************************************
Other related posts: