Skip to main content
14-Alexandrite
January 27, 2025
Solved

Identify starting points

  • January 27, 2025
  • 2 replies
  • 3318 views

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 

 

Best answer by terryhendicott

Capture.JPG

2 replies

21-Topaz II
January 27, 2025

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?

21-Topaz II
January 27, 2025
14-Alexandrite
January 27, 2025

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

YA_10963798_0-1737993214028.png

 

25-Diamond I
January 27, 2025

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

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

 

21-Topaz II
January 28, 2025
14-Alexandrite
January 28, 2025

Thank you Terry.