View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Finding name of a coumn that returned min value

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