excel FX function

J

jklen

I am trying use the logical function to find the MIN of more than 2 numbers and then have the column heading presented in an adjactent cell from which the MIN number was found
 
F

Frank Kabel

Hi
if your values are stored in A2:X2 (with the corresponding headings in
A1:X1) use the following functions:
1. To get the lowest number:
=MIN(A2:X2)

2. To get the corresponding column Heading from row 1 use
=INDEX($A$1:$X$1,1,MATCH(MIN(A2:X2),A2:X2,0))
 
Top