Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 351
- Office Version
- 365
- Platform
- Windows
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
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 |