Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding name of a coumn that returned min value
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. Kim wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coumn/Row highlight tracker | Excel Worksheet Functions | |||
need to know how to get the sum of right product returned | Excel Worksheet Functions | |||
Using the returned value of a function | New Users to Excel | |||
Error being returned | Excel Worksheet Functions | |||
#Value! Returned ? | Excel Worksheet Functions |