Identify starting points

[YA_10963798]

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 

Prime 10 is attached 

also the excel sheet 

[terryhendicott]

Can you answer one question:

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

In your file there are some negative values

Which do we follow?

[terryhendicott]

[YA_10963798]

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

[terryhendicott]

match as a function by default looks for equal values {you can change this}.  This means the depth must be in the CPT to get a match.

I have changed some of your start values to match values in the CPT's.  4.27 for 4.26, 4.15 for 4.14, 4.13 for 4.12.

If you wish to keep starting;z subscript cpt.pos as the values you have that do not appear in CPT's you can add the "geq" greater than or equal in the match function.

[YA_10963798]

Hi there 

The positive values 

[YA_10963798]

terry can you please help me fix this equation ... It will be more accurate if I just substruct them .. 

[terryhendicott]

subscript for two values is i subscript n, one is just i

One other correction I made is to add range_5 to definition of range it was missing. In your sheet range only has nine entries.

[YA_10963798]

See what I need is something like this forumla : the first start point from the first d ... so it loops twice .. and I should get this answer

I wrote a program , and I get these wrong answer:

can you help fix the program ?

Thanks 

[terryhendicott]

What is the correct output expected?

[YA_10963798]

Like this one 

[terryhendicott]

In your sheet range is missing range_5.  I added it. range in your sheet has nine entries

two values have index values i subscript n and one has index i use same index for all

[Werner_E]

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

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

[terryhendicott · Accepted solution]

[YA_10963798]

Thank you Terry. 

[YA_10963798]

Thank you Werner