On Fri, 14 May 2010 12:03:01 -0700, TimW
wrote:

Any simple way to count how many 1s and how many 2s here?
2
1
2
2
2
1
2
1
1
2
1
1

Have a look at the worksheet function COUNTIF

Hope this helps / Lars-Åke