Occurance Counting
Rusty
What would happen to the sheet if you removed the empty cells?
Select column A and F5SpecialBlanksOK
EditDeleteShift cells up.
OR DeleteEntire Row.
Gord Dibben MS Excel MVP
On Sun, 9 Jul 2006 08:43:01 -0700, Rusty
wrote:
Thank you. I tried it and it does work but with the empty cells in between
the rows it is not calculating correctly. Is there a way to correct that?
"pdberger" wrote:
Rusty --
Not the world's most elegant solution, but:
A B
1 8
2 8 =IF(A2<A1,1,0)
3 8
4 15
...
=SUM(B2:Bxxx)
HTH
"Rusty" wrote:
I really need some help for work. I have a column that contains various
numeric values and I want to count the number of times it changes from one
value to another, but there are spaces in between the cells. Heres a simple
example,
8
8
8
15
15
18
17
17
8
3
17
15
So, is there a formula or macro, something that can sum up the number of
times the number changes?
I would really appreciate the help.
|