using ROW number of MIN value

[jrtaylor]

I have two columns of data. I want to get a row number to create a formula, but I don't know how to use the reference function.

So: Column A, and Column B.

Formula says "take the minimum number in column B, tell me what row number it is in, and tell me what number is next to it in column A"

That way, if the minimum number in column B is cell B300, then I want to multiply the value in cell A300 times x.

Thanks!!

[p24leclerc]

Are the numbers in column B unique? I mean there is no duplicate. If duplicates exist which one should the formula returned?

[p24leclerc]

you can try this formula which will return the value in column A next to the minimum value in column B. You can multiply it by whatever you want.

Please Login or Register  to view this content.

[Tony Valko]

Try this...

Data Range

	A	B	C	D
1	68	49		66
2	5	90
3	68	74
4	48	81
5	66	32
6	73	46
7	61	48
8	18	50
9	20	93
10	47	53
11	------	------	------	------

This formula entered in D1:

=INDEX(A1:A10,MATCH(MIN(B1:B10),B1:B10,0))

[jrtaylor]

Thanks everyone. Yes, the min should be unique.

[Tony Valko]

You're welcome!

[Alba573]

Hello, is there a way to get the row header for the max & min as per attached.

[FlameRetired]

@ Alba573

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread