LinkBack URL
About LinkBacks
How can you count the number of times the values change in a column? For example the list of items below should generate 7 changes. Is there a count function to do this?
apple
apple
apple
pear
pear
orange
grape
grape
banana
apple
apple
orange
How can you count the number of times the values change in a column? For example the list of items below should generate 7 changes. Is there a count function to do this?
apple
apple
apple
pear
pear
orange
grape
grape
banana
apple
apple
orange
well i make that 6
apple to pear
pear to orange
orange to grape
grape to banana
banana to apple
apple to orange
=SUMPRODUCT(--(A1:A12<>A2:A13))-1 where a13 is a blank cell at the end of a list also gives 6
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks