I would like some help on a macro that would count the number of times
value appears in a column as well as seperate all the values in
seperate column.

Example:

Column A might have the values

ABC123
ABC123
ABC123
BCC123
BCC123
CBB123

Thus, column B would have the values:

ABC123
BCC123
CBB123

And column C would have the values

3
2
1

I would effectively be able to determine the total different number o
values in the column as well as the number of times each value appear
in the column.

Using the CountIf formula, I can determine the number of times eac
value appears in a column, but I am unable to determine the number o
different values.

Thanks

--
Kaziglu Be
-----------------------------------------------------------------------
Kaziglu Bey's Profile: http://www.excelforum.com/member.php...fo&userid=3608
View this thread: http://www.excelforum.com/showthread.php?threadid=57379