• Counting between major steps in data

    From David Cuthill@21:1/5 to All on Wed Mar 30 11:53:27 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)