Use Date to Find in Table

[Steve 1962]

Hi

I would like to change the date in cell F1, so that only the values in column E show. For example, if I change the date in cell F1 to 01/12/22, I would want only values from cells E16 to E22 to be displayed (all others to be blank). Each time the date in F1 is changed, it should only shows the required values in column E (progressive change based on the date set).

Thanks

Book1
	A	B	C	D	E	F
1	Date	Price	Units	Balance	Change	21/11/2022
2	14/11/2022	6.224	201516.0429	1254235.851
3	15/11/2022	6.2571	201516.0429	1260906.032	6670.18102
4	16/11/2022	6.2348	201516.0429	1256412.224	-4493.807757
5	17/11/2022	6.2452	201516.0429	1258507.991	2095.766846
6	18/11/2022	6.2332	201516.0429	1256089.799	-2418.192515
7	21/11/2022	6.2457	201516.0429	1258608.749	2518.950536
8	22/11/2022	6.2526	201516.0429	1259999.21	1390.460696
9	23/11/2022	6.259	201516.0429	1261288.913	1289.702675
10	24/11/2022	6.2775	201516.0429	1265016.959	3728.046794
11	25/11/2022	6.2831	201516.0429	1266145.449	1128.48984
12	28/11/2022	6.291	201516.0429	1267737.426	1591.976739
13	29/11/2022	6.2943	201516.0429	1268402.429	665.0029416
14	30/11/2022	6.2788	201516.0429	1265278.93	-3123.498665
15	1/12/2022	6.2783	201516.0429	1265178.172	-100.7580215
16	2/12/2022	6.3236	201516.0429	1274306.849	9128.676744
17	5/12/2022	6.3369	201516.0429	1276987.012	2680.163371
18	6/12/2022	6.343	201516.0429	1278216.26	1229.247862
19	7/12/2022	6.323	201516.0429	1274185.939	-4030.320858
20	8/12/2022	6.3066	201516.0429	1270881.076	-3304.863104
21	9/12/2022	6.2969	201516.0429	1268926.371	-1954.705616
22	12/12/2022	6.2925	201516.0429	1268039.7	-886.6705888
Sheet6

Cell Formulas
Range	Formula
E3:E22	E3	=D3-D2

 

[bebo021999]

Try in E3 then drag down:

=IF(A2<$F$1,"",D3-D2)

 

[Steve 1962]

Hey thanks very much bebo - works fine.

All the best.