counting changes in values in a column

[Rich]

I have a column in a spreadsheet that I want to count the
number of times the values changes. It repeats a value
for a range, changes, then changes back, changes to
another value, changes back, and so on. I can count the
number of unique numbers with something like "=SUM(IF
(FREQUENCY(P31000,P31000)>0,1))", but some of the
entries repeat, and I want to know how many times the
value changes, even if it repeats a number again. thanks.

 

[BrianB]

Make a new column with formula :=
=IF(A1=A2,0,1)
SUM the colum

 

[Rich]

-----Original Message-----
Make a new column with formula :=
=IF(A1=A2,0,1)
SUM the column

Thanks! That was too easy, and works fine.

rich

 

[Frank Kabel]

Hi
another way withou using a helper column would be
=SUMPRODUCT(--(A2:A100<>A1:A99))
assumptions: your values are stored in the range A1:A100