excel FX function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a value and returning corresponding info 3
Displaying time gaps 6
Finding Minimum but if same number repeats in the range, then find 1
How to to it in excel? 2
Selecting examples from a table 6
Min function with an offset 1
How to find a result in an array in the same row as a minimum resu 3
Time formula over two days 6

Back
Top