Counting occurences of text string in a text file
 

Hello. I know how to instr to find an occurence of a text string in a text
file, but I would like to count how many occurences of the string there are.

I am sure that I could create a routine that would do it, but is there a
built in function that I could use?

--
Thanks,
Mike

Counting occurences of text string in a text file
 

A B C
1 Make Month Price
2 Ford June 7,500
3 Ford June 8,300
4 Ford May 6,873
5 Ford June 11,200
6 Renault June 13,200
7 Renault June 14,999
8 BMW June 17,500
9 BMW May 23,500
10 BMW June 18,000

The solution for the number of Fords sold in June using this function is
=SUMPRODUCT((A1:A10="Ford")*(B1:B10="June")).
The value is obtained with
=SUMPRODUCT((A1:A10="Ford")*(B1:B10="June")*(C1:C1 0))

Take a look at this; you will probably learn a thing or two:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html


Regards,
Ryan---

--
RyGuy


"Mike Archer" wrote:

Hello. I know how to instr to find an occurence of a text string in a text
file, but I would like to count how many occurences of the string there are.

I am sure that I could create a routine that would do it, but is there a
built in function that I could use?

--
Thanks,
Mike