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!
|