About Us

Don Guillett

Glad to help

--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Sorry, didn't see your other suggestion when I did this post..........your
other one will do me just fine.........

Many thanks again,
Vaya con Dios,
Chuck, CABGx3

"Don Guillett" wrote:

???

--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Thanks Don, this new one requires the entire string to be UpperCase.
Can
it
be modified to be not case sensitive to any of the characters in the
string?

Vaya con Dios,
Chuck, CABGx3

"Don Guillett" wrote:

Sub countjohn()
For Each c In Selection
If InStr(UCase(c), "JOHN") 0 Then mc = mc + 1
Next c
MsgBox mc
End Sub

--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Thanks Don..........works good but seems to be "case
sensitive".......can
anything be done to change that?

Vaya con Dios,
Chuck, CABGx3

"Don Guillett" wrote:

something like
mc=0
for each c in selection
if instr(c,"John")0 then mc=mc+1
next c
msgbox mc
--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Hi All.......
How might the code read to perform a check of all cells in the
selected
column and count all the cells which contain a certain string at
least
once,
and place the total in cell B1. That is, if the string exists by
itself,
or
within a string of other characters in the same cell.....and if
multiple
times in one cell, only count once.

If looking for JOHN,
Cell with JOHN ...would count 1
Cell with JOHN/BILL /TOM & OTHERS... would count 1
Cell with JOHN / BILL,JOHN ...would count 1
Cell with BILL, TOM ...would not count
(note the inconsistant punctuation)

TIA for any help
Vaya con Dios,
Chuck, CABGx3

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string	Raja Mahendiran S	Excel Worksheet Functions	6	May 12th 10 09:10 PM
Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered	pmdoherty	Excel Worksheet Functions	4	February 6th 09 11:23 AM
Converting "uppercase" string data to "lower case" in CSV file	[email protected]	Excel Discussion (Misc queries)	2	August 12th 08 08:36 PM
text string: "91E10" in csv file auto converts to: "9.10E+11"	[email protected]	Excel Discussion (Misc queries)	2	August 12th 08 03:13 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM

Menu

About Us