PDA

View Full Version : optimization problem??


zaghumumar
11-06-2008, 07:33 AM
hi everyone,

i m facing the following problem.

i have around 10000 rows of data. i have to find minimum of each row. If i use excel solver, i have to run solver 10000 times, ofcourse impossible. any ideas how to find minima of each row in an efficient manner using may be Matlab.

regards,

umar.

tigergb
11-06-2008, 08:58 AM
in R/S+, try "apply",
in Matlab, simply use "min(x,2)"

daleholborow
11-06-2008, 09:12 AM
erm... if you have the data in excel, can't you simply use =min(A1:A10) to find the minimum of each row, where in this example A is the current row of data and you have values in the columns numbered 1-10?

that would get the minimum of each row and be very quick, or am i misunderstanding you?