Finding name of a coumn that returned min value

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
in F2:
=min($b2:$e2)

in g2:
=index($b$1:$e$1,match(f2,$b2:$e2,0))

Select F2:G2 and drag down as far as you need.

This will return the first minimum value--ties are not included.
 
Back
Top