Oct 10 2021 05:47 PM
Formulas to assist snippet below
I'm trying to figure out if Values in K column falls in between column D and E?? and have it present, in comumn F, if the turnout values is present between the upper and lower limit.
Column D being the lower limits for that particular chainage and E the Upper limit.
Now I want a formula to help out but I'm no expert in this, been trying to use If and function but doesn't seem right because there are multiple values of the turn out( columnK)??
=IF(AND(D2<$K$2,E2>$K$2),"Turnout","")
but I want to use all the turn out chainages?????
Please Help.
Oct 11 2021 12:19 AM - edited Oct 11 2021 12:24 AM
Solution@ExcelNovice365 -- Since you did not provide a file, I created my own data for illustration purposes. I hope its close enough to your actual data to understand.
I have concluded that you need to re-structure your data such that:
Once the above has been completed, you merely need to
Of course, COL F & G are oversimplified here for the purposes of illustration.
I challenge you to combine the "TurnoutTest" & "Turnout Or Not" columns into a single column.
See the attached file.
Lastly, if you need help TRANSPOSING tables data I suggest referencing this: https://stackoverflow.com/questions/60266169/dynamic-arrays-spill-horizontally
/C
Oct 11 2021 06:54 PM
Oct 11 2021 12:19 AM - edited Oct 11 2021 12:24 AM
Solution@ExcelNovice365 -- Since you did not provide a file, I created my own data for illustration purposes. I hope its close enough to your actual data to understand.
I have concluded that you need to re-structure your data such that:
Once the above has been completed, you merely need to
Of course, COL F & G are oversimplified here for the purposes of illustration.
I challenge you to combine the "TurnoutTest" & "Turnout Or Not" columns into a single column.
See the attached file.
Lastly, if you need help TRANSPOSING tables data I suggest referencing this: https://stackoverflow.com/questions/60266169/dynamic-arrays-spill-horizontally
/C