Finding high price and the date it occurred

[tjlutz]

Hi Everyone! I'm trying to extract the date the highest price took place for livestock. I get weekly prices for price/lb. I certainly would appreciate any help with this matter. Thanks so much in advance!

Date	low weight	hi weight	low	high
10/24/2019​	30​	50​	$ 1.00	$ 1.50
10/24/2019​	51​	60​	$ 1.00	$ 1.50
10/24/2019​	61​	70​	$ 1.50	$ 1.70
10/24/2019​	71​	80​	$ 1.45	$ 1.55
10/24/2019​	81​	90​	$ 1.35	$ 1.50
10/24/2019​	91​	100​	$ 1.30	$ 1.40
10/24/2019​	101​	110​	$ 1.30	$ 1.40
10/24/2019​	111​	120​	$ 1.35	$ 1.50

 

[Fluff]

What version of Excel are you using?
Please update you account details to show this, as it affects which functions you can use.

 

[tjlutz]

Excel 2010

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G
1	Date	low weight	hi weight	low	high
2	24/10/2019	30	50	1	1.5		26/10/2019
3	25/10/2019	51	60	1	1.5
4	26/10/2019	61	70	1.5	1.7
5	27/10/2019	71	80	1.45	1.55
6	28/10/2019	81	90	1.35	1.5
7	29/10/2019	91	100	1.3	1.4
8	30/10/2019	101	110	1.3	1.4
9	31/10/2019	111	120	1.35	1.5
10
Data

Cell Formulas
Range	Formula
G2	G2	=INDEX(A2:A9,MATCH(MAX(E2:E9),E2:E9,0))

And please remember, to updtae your account details