Finding a value based on multiple conditions of the next row

I need to find the row in a csv that comes right before a row where multiple conditions are met for example, the .csv look something like:

I basically need the DisttoStartPoint at of Procedure 1 when Procedure 2 has a DriveTime of <1

I can get the DistToStartPoint of the Procedure 2 by using condtions but I can not figure out how to get the info from the previous row.

Thank you.

Answer 1

[KSSV]

idx = find(DrivenTime(Procedure==2)) ;
PReviousRow = idx(1)-1

[Jorge Young]

this seems to work great, my csv is very large with multple procedures. Is there a way to apply this to the whole file and not just the first instance the conditions are met?

[KSSV]

[c,ia,ib] = unique(Procedure) ; 
for i = 2:length(c)
    idx = find(DrivenTime(Procedure==c(i))<1) ;
    if ~isempty(idx)
        PreviousRow = idx(1)-1 ; 
    end
end

[Jorge Young]

perfect! thanks!