Command to get specific row and column data to be displayed in the code

I wish to get the value of Voltage(First column) where my current(Second) changes its sign from negative to positive(or Vice versa there is not much difference in the two adjacent values). Can anyone suggest which command should i use to extract the voltage from the given spreadsheet and display it in my script?

[madhan ravi]

Try specifying the range as 'A1731:B1732'

Answer 1

[KSSV]

% Make dummy data 
A = [rand(10,1) rand(10,1)] ;
s = ones(10,1) ; 
s(1:5) = -1; 
A(:,2) = s.*A(:,2) ;
% get index of sign change
s = sign(A(:,2)) ;
idx = find(diff(s)~=0) ;
iwant = A(idx:idx+1,:)