Hi,
i'm struggeling with quite a complex issue (for me at least haha). I've a column with words 'wheel' and 'interval'. I want to count the number of times 'interval' is present in the column, but only if in 10 subsequential cells 'interval' is present 2 times. So not count interval in the case of "wheel-wheel-wheel-wheel-wheel-interval-wheel-wheel-wheel-wheel', but counting it in the case of 'wheel-interval-wheel-wheel-wheel-wheel-wheel-interval-wheel-wheel', as i need a threshold of when counting interval (It is about revolutions of a running wheel with mice, so one revolution does not count as 'activity', whereas two revolutions in a short time period do).
I really hope this makes a little bit sense and that somebody can help me!
Kind regards,
Femke
i'm struggeling with quite a complex issue (for me at least haha). I've a column with words 'wheel' and 'interval'. I want to count the number of times 'interval' is present in the column, but only if in 10 subsequential cells 'interval' is present 2 times. So not count interval in the case of "wheel-wheel-wheel-wheel-wheel-interval-wheel-wheel-wheel-wheel', but counting it in the case of 'wheel-interval-wheel-wheel-wheel-wheel-wheel-interval-wheel-wheel', as i need a threshold of when counting interval (It is about revolutions of a running wheel with mice, so one revolution does not count as 'activity', whereas two revolutions in a short time period do).
I really hope this makes a little bit sense and that somebody can help me!
Kind regards,
Femke