How to find the closest value to a constant in a 2D matrix

Hello,

I have a 2D matrix of random numbers and NaNs, of 15x129. I want to find where in the matrix the values are closest to the number 15 along each column, and output a logical 15x129 matrix (where number is closest to 15 = 1, where number is less than 15 = 0 or nan) . So out of the 15 values, which value is closest to the number 15.

Thank you,

Holly

[Sargondjani]

Did you even search for an answer?

Maybe this can help:

https://stackoverflow.com/questions/51078880/find-closest-value-to-a-constant-in-a-multidimensional-array-in-matlab

Answer 1

[YT]

Probably something like this

A = rand([15 129])*100; %matrix with random values
[~,I] = min(abs(A - 15),[],1); %get indices for values closest to 15

logicalMat = false(size(A)); %preallocate logical matrix

arrayLength = size(A,2);
for jj = 1:arrayLength
    logicalMat(I(jj),jj) = 1; %fill logical matrix
end

[HA]

This works great, thank you!