Fetch the cell next to MIN/MAX -value?

[Kribulin]

For instance:

The months are in column A and the corresponding values in column B:

[January] [5]
[February] [8]
[March] [3]
[April] [9]
[May] [2]

Result:

[fetch A5 because MIN is "B5"] [MIN="B5"]

[fetch A4 because MAX is "B4"] [MAX="B4"]


Thanks in advance!

 

[Peter_SSs]

Kribulin

Is it possible that more than 1 row will contain equal max or equal min values? If so, what do you want to happen?

 

[Kribulin]

Basically, it is impossible because of a large number of decimals, so I'd say that that possibility can be skipped.

 

[Peter_SSs]

Basically, it is impossible because of a large number of decimals, so I'd say that that possibility can be skipped.

In that case, try:

Excel Workbook
	A	B	C	D	E	F	G
1	January	5			Max	Min
2	February	8			April	May
3	March	3
4	April	9
5	May	2
6
7
Max Min

 

[Kribulin]

Brilliant, thank you very much!