Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Counting between major steps in data

20 views
Skip to first unread message

David Cuthill

unread,
Mar 30, 2022, 2:53:29 PM3/30/22
to
I have a column of data that I want to step through and count how many values there are between each major value. So from value 18.00 to 17.75 there are 4 values; from 17.75 to the next 17.75 there are 3 values. I then want to summarize the outcome in a column as ...

4
3
2
4
....


The major and minor values can vary.

I'm sure how to attack this problem and would appreciate some guidance.

thanks



Example data set
18.00
0.08
0.08
0.08
17.75
0.08
0.08
17.75
0.08
17.75
0.08
0.08
0.08
17.75
0.08
0.08
0.08
17.75
0.08
0.08
0.08
17.75
0.08
0.08
0.08
17.75
0.08
0.08
0.08
0 new messages