S
Stephen Doyle
In a cell I have a line of ticks, how do I count them?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Try this:-
=COUNTIF(A1:A100,"="&CHAR(252))
Mike
=COUNTIF(A1:A100,"="&CHAR(252))
Mike
B
Bob Phillips
depends upon what drives the tick. For instance I use a with a font of
Marlett, so I just need
=COUNTIF(rng,"a")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Marlett, so I just need
=COUNTIF(rng,"a")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
M
Mike H
Or any of these:-
Character to Type Font to Use
a Marlett
a Webdings
b Marlett
C Erilogo
P Wingdings 2
Alt+129 Wingdings
Alt+0214 Symbol
Alt+0252 Wingdings
Mike
Character to Type Font to Use
a Marlett
a Webdings
b Marlett
C Erilogo
P Wingdings 2
Alt+129 Wingdings
Alt+0214 Symbol
Alt+0252 Wingdings
Mike
S
Stephen Doyle
addy)Mike H said:Or any of these:-
Character to Type Font to Use
a Marlett
a Webdings
b Marlett
C Erilogo
P Wingdings 2
Alt+129 Wingdings
Alt+0214 Symbol
Alt+0252 Wingdings
Mike
I ended up using =LEN()
Works a treat
Cheers
Stephen