searching for occurances of txt

  • Thread starter Thread starter alistair01
  • Start date Start date
A

alistair01

Im a bit stuck with this problem, basically i am trying to count the
occurances of txt within a column. This is a database with a misc.
entry and i want a formula that will return the number of times a cell
that contains eg. "z1". there is more text within the cell.
 
=COUNTIF(A:A,"*z1*")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
count number of occurances between 2 values 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Counting the number of times a character occurs in a cell 1
Count range of cells if not next to each other 0
Counting occurances based on multiple variables 4
Auto Import OR Searching TXT Data 1
SUMPRODUCT containing txt string search 6

Back
Top