Hi Jason

As an alternative to Sandy's suggestion, you could use
Select column E:FDataConsolidateFunction CountSourceA:BUse labels
in Left ColumnOK

After data changes. just choose DataConsolidateOK


--
Regards

Roger Govier


"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.