Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Hi,
can someone please help me?
I want to find minimum non-zero value, in col B and its respective values in col A & C.
Thanks in advance.
Solved! Go to Solution.
As you are asking for a solution in Mathcad (I assume that you mean Prime), you should show the data format in Mathcad, not a screenshot of a Excel spreadsheet.
And you sure should attach your worksheet with the data.
Its a difference if the data is provided as a matrix in Prime or in a Prime table. The latter would basically mean that the data is in three different columns.
If that's the case, a solution could be
If the data is in one whole matrix like in Terry's sheet (which I had used to avoid having to retype the data), a similar solution is possible using the column selector
Of course you could replace ORIGIN by the value used in your sheet (possibly 0) to make the expression look a bit less ugly
Its actually a 4-step procedure as well 😉
P9 worksheet attached
As you are asking for a solution in Mathcad (I assume that you mean Prime), you should show the data format in Mathcad, not a screenshot of a Excel spreadsheet.
And you sure should attach your worksheet with the data.
Its a difference if the data is provided as a matrix in Prime or in a Prime table. The latter would basically mean that the data is in three different columns.
If that's the case, a solution could be
If the data is in one whole matrix like in Terry's sheet (which I had used to avoid having to retype the data), a similar solution is possible using the column selector
Of course you could replace ORIGIN by the value used in your sheet (possibly 0) to make the expression look a bit less ugly
Its actually a 4-step procedure as well 😉
P9 worksheet attached
If you are using EXCEL conpornent, only output the data cells you want.