thanks Sandy,

The reason I can't use a standard count function is that there will
potentially be thousands of account #'s. I would like a formula that looks
at all of the matching account #'s & counts a field based on that.

The data consolidation function sounds like it may work, but I'm not
familiar with that & so far have not had luck.

"Sandy Mann" wrote:

To count the instances of 001 use:

=COUNTIF(B3:B6,"001")

Where B3:B6 is the list of accounts but I can't help but think that you atre
actually asking for soemthing else.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jason" wrote in message
...
not sure if this is possible...I need to get a count of values in a
column,
but the column has multiple repeats of the same. it looks something like
this..

account market value
0001 $10,000
0001 $9000
0002 $8000
0002 $12,000

I would need to see that there are 2 instances of account 0001 and 2
instances of account 0002.