Hi,

First of all, give a heading to the column. Create a pivot table - drag the
column to the row areas and drag it again to the data area. Right click on
any number, select field settings and select count

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"TimW" wrote in message
...
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