But what do you mean B2? Is cell B2? Just like finding text that start with F in Column B: =COUNTIF(B1:B52; "F.*")
2010/8/12 Wade Smart <[email protected]> > I have a column with a string in it: > > Firstname Lastname, Position, Gender, Age, Identifier > > I have 52 columns each with cells contained the above data per cell. > > I wouldnt to do something like countif(B2 has "F") => count if B2 has > Female present in the string. > > Wade > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
