counting changes in values in a column

R

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(P3:p1000,P3:p1000)>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.
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Count Number of Unique Cells That Don't Have Certain Characters 0
count unique values with auto-filter on 6
need help on either doing a loop and counting specific values orusing subtotal function 2
Duplicate entry in a column/row 14
Count Unique Values in a entire column, not just range 10
Counting 3
Trying to count based on multiple criteria & cell comparisons 4

Top