Pulling column headings using MIN

[Corinthianw]

I have a table that monitors how many contacts are made via phone, in person, in store and various other methods. The columns have headings representing the contact methods while the rows contain information for each sales person. I linked the cells in this table to another table that shows the lowest method of contact. I did this using the MIN function. I am looking for a way for Excel to pull the column heading into the table as well as the value so I know what contact method they are using least instead of having to go to the table and find the value and column heading. Any help would be greatly appreciated.

[DonkeyOte]

You can use INDEX with MATCH & MIN, eg

=INDEX(Sheet1!$A$1:$J$1,MATCH(MIN(Sheet1!$A2:$J2),Sheet1!$A2:$J2,0))

would pull header associated with MIN value found in A2:J2, copied down you would get headers associated with row 3, 4 etc...

(worth noting that if there are multiple instances of MIN value the above will return only the header associated with the first MIN value found... if you need all returned in one cell then you're looking at far more complex solutions I'm afraid)

[sweep]

Hi,

If your data is in C2:F30, and headings are in row 1,

This array

=MIN(IF(A1:C30=MIN(C2:F30),COLUMN(C2:F30),""))

returns the column number that contains the 1st minimum in a range. Use this number in an index statement to return the header, another array:

=INDEX(A1:F1,MIN(IF(NumRange=MIN(C2:F30),COLUMN(C2:F30),"")))