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

Back
Top