Hello, I was wondering how would I set up a formula where it would count a range of cells but avoiding duplicates in a row?
Red
Red
Red
Blue
Blue
Blue
Red
Red
Red
Yellow
Yellow
So an example would be, this would be 4 counts. It would avoid duplicates but only if it in a row like that.
Thank you
Bookmarks