G
Guest
Hi
Please can you help
I have 4 columns with the name of labs as the headers, below the is a number
of costs for certain tests. What I would like to do is have two columns, one
that returns the minimum value (hence min function) and the next column to
return the name of the lab the minium value comes from. E.g.
STL NIRAS GSL Scien. Min Name
Cu 12 13 6 8 6 GSL
As 12 13 6 8 6 GSL
pH 10 10 11 12 10 STL NIRAS
Any ideas?
Thank you
Please can you help
I have 4 columns with the name of labs as the headers, below the is a number
of costs for certain tests. What I would like to do is have two columns, one
that returns the minimum value (hence min function) and the next column to
return the name of the lab the minium value comes from. E.g.
STL NIRAS GSL Scien. Min Name
Cu 12 13 6 8 6 GSL
As 12 13 6 8 6 GSL
pH 10 10 11 12 10 STL NIRAS
Any ideas?
Thank you