Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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
Solved! Go to Solution.
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?
why I having this error , did I write it wrongly?
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.
Hi there
The positive values
terry can you please help me fix this equation ... It will be more accurate if I just substruct them ..
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.
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
What is the correct output expected?
Like this one
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
Not sure but are you looking for something like shown in the attached file?
I prefer programmed for loops over worksheet range variables...
Thank you Terry.
Thank you Werner