excel problem
i have this problem in excel and i believe i need to use vba to overcome it however because i am incompentent in programing i would really appreciate the help of someone
i have a column containing a huge list of numbers
a small example would be the following
2
2
2
6
6
8
8
8
2
2
2
2
2
5
5
i need the column next to it to automatically show how many times each number repeated (not how many times each number appeared in the whole column but how many times the same number occurs repeatedly before a new numbers occurs)
so the result would be
2
2
2 3
6
6 2
8
8
8 3
2
2
2
2
2 5
5
5 2
ie 2 appeared 3 times
then 6 appeared twice
then 8 appeared 3 times
then 2 appeared another 5 times
then 5 appeared twice
it would reall help me if the second column numbers were displayed just as they are above at the end of each sequnce in the next cloumn
if i have been unclear at all please let let me know and i will try to explain with greater clarity
thank you if anyone can help
|