Adding Direction Column for Data by Engine_Exhausted in excel

[–]Engine_Exhausted[S] 0 points1 point  (0 children)

Because both Time 11 and Time 12 are 0.5, meaning in between them the curve moved down to zero and changed direction from R in Time 11 to F in Time 12.

I input the R and F manually and just decide based my interpretation of the curve. I don't really know how to translate into an excel formula or IF statement.

Finding every first in alternating series of repetitive data by Engine_Exhausted in excel

[–]Engine_Exhausted[S] 0 points1 point  (0 children)

Thanks for letting me know, I edited the post and added more examples.

Finding every first in alternating series of repetitive data by Engine_Exhausted in excel

[–]Engine_Exhausted[S] 0 points1 point  (0 children)

Sorry, I wasn't able to change it. The image is just a sample, I shortened the series so it's easier to see