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