Home |
Search |
Today's Posts |
#1
|
|||
|
|||
return header as result in excel
How do I find the minimum of a range and return the header as the result?
|
#2
|
|||
|
|||
With values in row 2 and headers in row 1:
=INDEX(1:1,MATCH(MIN(2:2),2:2,0)) Array-entered. HTH Jason Atlanta, GA -----Original Message----- How do I find the minimum of a range and return the header as the result? . |
#3
|
|||
|
|||
Jason Morin wrote:
With values in row 2 and headers in row 1: =INDEX(1:1,MATCH(MIN(2:2),2:2,0)) Array-entered. That shouldn't require to be "array-entered". |
#4
|
|||
|
|||
An Index/Match formula (see Jason's reply) will return the header
corresponding to the first instance of the minimum value. For example: A1:C1 houses Jan, Feb, and Mar A2:C2 houses 20, 40, 20 The answer will be Jan, while it should be: Jan and Mar. The following link describes a formula system that takes care of the ties: http://tinyurl.com/5txnx NN wrote: How do I find the minimum of a range and return the header as the result? |
#5
|
|||
|
|||
You're right. I habitually press ctrl/shift/enter on most
of my INDEX formulas w/out examining the need for it first. Good catch. Jason -----Original Message----- Jason Morin wrote: With values in row 2 and headers in row 1: =INDEX(1:1,MATCH(MIN(2:2),2:2,0)) Array-entered. That shouldn't require to be "array-entered". . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |