Get column E based on transition in Column I

Hello,

I have imported a spreadsheet into Matlab and am trying to look at where column I transitions from a 1 to a 0.

When that transition is determined, I then need to take the value of column E.

Could anyone help me do this? I have attached an image to this request.

Thank you in advance!

Answer 1

[Dyuman Joshi]

y=[1 1 1 1 1 0 0 0 0 1 1 0 1 0 1 1 0 0 0 0 0 0 0];
i=find(diff(y)==-1)+1

i = 1×4

6 12 14 17