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)
 
Back
Top