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