Data Advanced Filter select Copy to another location List range: select
your range Copy to: select any blank cell click Unique records only OK

After you have all the unique records, then use Countif function


"Jason" wrote:

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.