Hi there , I was looking for some help on a problem I have with excel.
What I am trying to do is count how many times a specific number is immediately followed by another specific number in a long list of time series of data.
For instance say I have 5000 numbers in cells A1:A5000 these numbers all range from 0 to 1.What I want to do is count the number of times that the number 0.5 is followed by 0.51 so the example below would return a value of 2 as 0.5 is immediately followed by 0.51 twice.
Does anyone know how to achieve this?
A
0.5
0.51
0.6
0.6
0.5
0.51
0.7
0.51
0.6
Thank you
Bookmarks