=COUNTIF(A:A,Account_id)
--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"anniejhsu" wrote
in message ...

Hi,

I'm trying to figure out how to count the number of occurrences of any
given account identification number in a column. I'd like to get the
information in this type of format:

Account ID: Frequency
58024: 10
37395: 12
74914: 3

What's the most efficient way to do this?

Many thanks in advance.

Annie


--
anniejhsu
------------------------------------------------------------------------
anniejhsu's Profile:
http://www.excelforum.com/member.php...o&userid=34961
View this thread: http://www.excelforum.com/showthread...hreadid=546966