Hello everyone,
I have encounterd a problem when I try to count two consecutive number. For example: I want to count how many number 1 followed by number 0 in a set of data. I try COUNTIF but it seems to not work. Thank you in advance. See the attached file
Consecutive.xlsx
Bookmarks