Count only if next cell changes its value

**fulldeen** · 10-13-2012, 12:15 AM

Good morning to all of you.
please look at the attachment to see what ia need.
Regards..

**benishiryo** · 10-13-2012, 12:33 AM

hi fulldeen, try:
=IF(AND(D2<>D1,D1<>"Names"),F1+1,F2)

**fulldeen** · 10-13-2012, 01:02 AM

i get 0,0,0,0,,,, everywhere.
could you please get a second look?
thank you very much

**benishiryo** · 10-13-2012, 01:08 AM

sorry, should be:
=IF(AND(D2<>D1,D1<>"Names"),F1+1,G1)

**fulldeen** · 10-13-2012, 01:24 AM

thank you.

**fulldeen** · 10-13-2012, 01:51 AM

thank you about the attachment.
here it is.

**benishiryo** · 10-13-2012, 02:06 AM

ahhh nothing to do with you. dont know why i kept giving a wrong solution. here it is:
=IF(AND(D2<>D1,D1<>"Names"),F1+1,F1)

**fulldeen** · 10-13-2012, 02:12 AM

thats it.
Many thanks to all of you

Re: Count only if next cell changes its value