Skip to main content
15-Moonstone
Jan 27, 2025 2:35 PM UTC
Solved

Identify starting points

Hi there

 

I have some data of depth of 10 inputs  but I need the calculation to start from single point in each input and ignore the one above : for example the starting point of first input is 1.31 but its depth starts from (0) ...so I need the program to ignore all the data from 0 to 1.31 and starts at 1.31.

the second input d2 has values from 0.5  I need the program to ignore this values and starts from 1.26 

so basically it eliminates all the points before the starting points I decided 

YA_10963798_0-1737988196850.png

Prime 10 is attached 

also the excel sheet 

 

terryhendicott
21-Topaz II
Jan 28, 2025 1:46 PM UTC

Capture.JPG

15 replies

terryhendicott
21-Topaz II
Jan 27, 2025 3:20 PM UTC

Can you answer one question:

In screen grab in post all values of starting point are positive

Capture2.JPG

In your file there are some negative values

Capture.JPG

Which do we follow?

Translate
terryhendicott
21-Topaz II
Jan 27, 2025 3:42 PM UTC
15-Moonstone
Jan 27, 2025 3:53 PM UTC

why I having this error , did I write it wrongly?

YA_10963798_0-1737993214028.png

 

Translate
Werner_E
25-Diamond I
Jan 27, 2025 6:41 PM UTC

Not sure but are you looking for something like shown in the attached file?

I prefer programmed for loops over worksheet range variables...

 

Translate
terryhendicott
21-Topaz II
Jan 28, 2025 1:46 PM UTC
15-Moonstone
Jan 28, 2025 3:40 PM UTC

Thank you Terry. 

Translate