View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
medirate medirate is offline
external usenet poster
 
Posts: 6
Default Count unique instances of text in column

I have a column of text where I need to count the unique values. The column
of text is in another worksheet called Dist. The column of data may look
like this:

24509
13450
24509
18709
24509
13450

I have no idea what the column of data may contain beforehand, so I can't do
a count of "24509", but I need the result to look like this:

24509 3
13450 2
18709 1

Any suggestions?

Thanks!