Hi Everyone,
I have a column of data that looks like this (assume A1:A9):
11
88
88
11
44
44
88
88
88
I'm looking for a formula in column B to calculate the count of values (rows) of most recent consecutive streak of a value; i.e. B9 would calculate '3' for 88, '2' for 44 and '1' for 11. My data is chronological in ascending order.
I've been scratching my head and google searching for the correct combination of Count, Rows, Frequency, etc. functions to get the correct result - but struggling...
Thanks for any and all effort!
Bookmarks