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?

 

[Cubist]

What does your data look like? Are the date sorted? Please post a sample.

 

[awoohaw]

can you post some sample data using the xl2bb add in? Also, are there duplicates in your list of values you are scanning through?

 

[Justinian]

I tried xl2bb but it says not supported in protected view.

 

[awoohaw]

I tried xl2bb but it says not supported in protected view.

Then post the data as a table. Highlight a1:B25. Copy, come to start a reply post
here. click in the posting area, click paste or CNTL-V.

 

[Cubist]

I tried xl2bb but it says not supported in protected view.

See this thread.

 

[Justinian]

Got it:

Book1
	A	B
1	1/2/2024	1020
2	1/3/2024	1079
3	1/4/2024	1106
4	1/5/2024	1097
5	1/8/2024	1250
6	1/9/2024	1304
7	1/10/2024	1316
8	1/11/2024	1352
9	1/12/2024	1335
10	1/15/2024	1372
11	1/16/2024	1366
12	1/17/2024	1403
13	1/18/2024	1381
14	1/19/2024	1335
15	1/22/2024	1410
16	1/23/2024	1419
17	1/24/2024	1374
18	1/25/2024	1331
19	1/26/2024	1296
20	1/29/2024	1332
21	1/30/2024	1359
22	1/31/2024	1334
23	2/1/2024	1330
24	2/2/2024	1323
25	2/5/2024	1530
26	2/6/2024	1620
27	2/7/2024	1646
28	2/8/2024	1661
29	2/9/2024	1527
30	2/12/2024	1536
31	2/13/2024	1523
32	2/14/2024	1414
33	2/15/2024	1337
34	2/16/2024	1253
35	2/19/2024	1280
36	2/20/2024	1190
37	2/21/2024	1169
38	2/22/2024	1190
39	2/23/2024	1106
40	2/26/2024	1099
41	2/27/2024	1085
42	2/28/2024	1048
43	2/29/2024	987
44	3/1/2024	955
45	3/4/2024	982
46	3/5/2024	980
47	3/6/2024	957
48	3/7/2024	920
49	3/8/2024	836
50	3/11/2024	876
51	3/12/2024	822
52	3/13/2024	825
53	3/14/2024	811
54	3/15/2024	743
55	3/18/2024	745
56	3/19/2024	743
57	3/20/2024	686
58	3/21/2024	631
59	3/22/2024	542
60	3/25/2024	578
61	3/26/2024	500
62	3/27/2024	504
63	3/28/2024	473
64	3/29/2024	485
65	4/1/2024	490
66	4/2/2024	479
67	4/3/2024	477
68	4/4/2024	438
69	4/5/2024	402
70	4/8/2024	441
71	4/9/2024	421
72	4/10/2024	399
73	4/11/2024	391
74	4/12/2024	377
75	4/15/2024	371
76	4/16/2024	350
77	4/17/2024	297
Sheet1

 

[shaowu459]

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)

 

[Cubist]

When you have multiple instances of the same min, which date do you want to return?

 

[Justinian]

When you have multiple instances of the same min, which date do you want to return?

So far, there have not been duplicates, in which case the most recent date will be the one I want.