Return Value to the Left of Minimum Value

[Justinian]

I am tracking work order production so I have dates in column A and values in column B. I am trying to search for the minimum value in column B and return the date directly to the left of that minimum value. I searched and tried INDEX MATCH and OFFSET but they are not working.

Any ideas?

 

[Justinian]

have a try:

工作簿1
	A	B	C	D	E
1	data	value		date
2	2024-4-18	16		2024-4-24
3	2024-4-19	72
4	2024-4-20	97
5	2024-4-21	4
6	2024-4-22	9
7	2024-4-23	53
8	2024-4-24	1
9	2024-4-25	19
10	2024-4-26	84
11	2024-4-27	44
12	2024-4-28	30
13	2024-4-29	76
14
Sheet1

Cell Formulas
Range	Formula
D2	D2	=TOCOL(A2:A13/(B2:B13=MIN(B2:B13)),3)
B2:B13	B2	=RANDBETWEEN(1,99)

Never thought to use TOCOL.

Thank you!

 

[Cubist]

There are duplicate in the provided sample.

Book1
	A	B	C
4	1/4/2024	1106	2
10	1/12/2024	1335	2
15	1/19/2024	1335	2
37	2/20/2024	1190	2
39	2/22/2024	1190	2
40	2/23/2024	1106	2
55	3/15/2024	743	2
57	3/19/2024	743	2
Sheet2

Cell Formulas
Range	Formula
C4,C10,C15,C37,C39:C40,C55,C57	C4	=COUNTIF($B$2:$B$78,B4)

Anyhow, try

=XLOOKUP(MIN(B1:B77),B1:B77,A1:A77,,,-1)

 

[shaowu459]

Glad we could help, thanks for the feedback.

 

[Justinian]

There are duplicate in the provided sample.

Book1
	A	B	C
4	1/4/2024	1106	2
10	1/12/2024	1335	2
15	1/19/2024	1335	2
37	2/20/2024	1190	2
39	2/22/2024	1190	2
40	2/23/2024	1106	2
55	3/15/2024	743	2
57	3/19/2024	743	2
Sheet2

Cell Formulas
Range	Formula
C4,C10,C15,C37,C39:C40,C55,C57	C4	=COUNTIF($B$2:$B$78,B4)

Anyhow, try

=XLOOKUP(MIN(B1:B77),B1:B77,A1:A77,,,-1)

Awesome, thank you!

There are duplicate in the provided sample.

Book1
	A	B	C
4	1/4/2024	1106	2
10	1/12/2024	1335	2
15	1/19/2024	1335	2
37	2/20/2024	1190	2
39	2/22/2024	1190	2
40	2/23/2024	1106	2
55	3/15/2024	743	2
57	3/19/2024	743	2
Sheet2

Cell Formulas
Range	Formula
C4,C10,C15,C37,C39:C40,C55,C57	C4	=COUNTIF($B$2:$B$78,B4)

Anyhow, try

=XLOOKUP(MIN(B1:B77),B1:B77,A1:A77,,,-1)

Awesome, thank you!