Count the occurance of "1)"

[RichardMau5]

Hello Guys,

While I was working on my scription, I needed to count the occurance of "1)"
Excel finds it really hard to do this, I believe.

This is a little piece of my data:

0 (1,0)	1 (2,1)	2 (2,1)	3 (2,2)	5 (2,2)	6 (2,2)	9 (2,2)	11 (2,3)	18 (2,2)	20 (2,2)
24 (2,2)	25 (2,3)	26 (2,3)	28 (2,3)	32 (2,1)	33 (2,2)	34 (2,2)	36 (2,2)	40 (2,2)	41 (2,3)
56 (2,3)	80 (2,2)	85 (2,4)	88 (2,3)	96 (2,2)	144 (2,2)	145 (2,3)	146 (2,3)	153 (2,4)	176 (2,3)
260 (2,2)	264 (2,2)	265 (2,3)	266 (2,3)	268 (2,3)	280 (2,3)	296 (2,3)	320 (2,2)	328 (2,3)	384 (2,2)
385 (2,3)	386 (2,3)	388 (2,3)	392 (2,3)	393 (2,4)	400 (2,3)	408 (2,4)	416 (2,3)	448 (2,3)	520 (2,2)
521 (2,3)	536 (2,3)	576 (2,2)	641 (2,3)	656 (2,3)	776 (2,3)	1285 (2,4)	1288 (2,3)	1360 (2,4)	2305 (2,3)

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

So, I want to filter out, how many ,1) or 1)'s there are, how many 2)'s etc.

Is this actually possible?

Many thanks beforehand

 

[NBVC]

Maybe with COUNTIF?

e/g/

=COUNTIF(A1:J6,",1)")

 

[Jonmo1]

Maybe with COUNTIF?

e/g/

=COUNTIF(A1:J6,",1)")

Probably need to add a wildcard in there..

=COUNTIF(A1:J6,"*,1)")

 

[RichardMau5]

Holymoly, it worked. Had to edit a bit to

=COUNTIF((A1:J6); "*,1)")

Thankyou so, so much guys!

 

[pgc01]

Hi Richard

Do you really need to enclose the reference in parentheses?

=COUNTIF((A1:J6); "*,1)")

Try deleting those parentheses.

 

[NBVC]

Thanks for the correction, jonmo