function for reporting adjacent cell to minimum

Question

I thought MINIFS would do this, but apparently not. I have two columns of numbers, for example

A  B

1  5

2  6

3  7

4  8

and I want to display in a cell below the number in column A that corresponds to the minimum value in column B. Which, in this example, would display "1" because the minimum value in B is "5". Is there a function that will do this? What would be the syntax, if so?

Answer 1

Hi,

In cell A7, enter this formula

=INDEX($A$2:$A$5,MATCH(MIN($B$2:$B$5),$B$2:$B$5,0),1)

Data is in range A2:B5

Hope this helps.

Answer 2

No. Only one cell is required. These are two alternative formulas. You can use either of the formulas. I just gave two different formulas. Sorry for not making it clear.

Answer 3

Hello doggod42

I am V. Arya, Independent Advisor, to work with you on this issue. Use below formula

=INDEX($A$1:$A$4,MATCH(MIN($B$1:$B$4),$B$1:$B$4,0))

=AGGREGATE(15,6,$A$1:$A$4/($B$1:$B$4=MIN($B$1:$B$4)),1)

Answer 4

Oh, thank you a lot then!

Answer 5

So it requires two cells then? One for the =index function and one for the =aggregate? Where does the answer appear?