Just list the 50 possible somewhere, say M1:M50, and use

=COUNTIF(A:A,M1)

and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"dannyboy213"
wrote in message
...

The problem is I don't know which states are on the list because the
list is too long.
poloboyUK Wrote:
Have you tried fully utilising the COUNT function.

Just spit-balling but COUNT("Ca") for example. Does that work or not?


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile:
http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=507788