MrExcelPlayground19.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 10/28/2023 | |||||
2 | 11/22/2023 | Year | 2024 | |||
3 | 12/17/2023 | |||||
4 | 1/11/2024 | Min | 1/11/2024 | |||
5 | 2/5/2024 | |||||
6 | 12/26/2024 | Max | 12/26/2024 | |||
7 | 1/20/2025 | |||||
8 | 2/14/2025 | |||||
9 | 3/11/2025 | |||||
Sheet15 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D4 | D4 | =MIN(FILTER(A1:A9,YEAR(A1:A9)=D2)) |
D6 | D6 | =MAX(FILTER(A1:A9,YEAR(A1:A9)=D2)) |
MrExcelPlayground19.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Date | Thing 1 | Thing 2 | … | Thing N | ||
2 | 10/28/2023 | 235 | 735 | 984 | 372 | ||
3 | 11/22/2023 | 592 | 814 | 525 | 796 | ||
4 | 12/17/2023 | 573 | 210 | 882 | 132 | ||
5 | 1/11/2024 | 828 | 899 | 876 | 872 | ||
6 | 2/5/2024 | 858 | 458 | 569 | 703 | ||
7 | 12/26/2024 | 101 | 846 | 141 | 607 | ||
8 | 1/20/2025 | 909 | 105 | 561 | 576 | ||
9 | 2/14/2025 | 822 | 217 | 629 | 402 | ||
10 | 3/11/2025 | 882 | 640 | 636 | 422 | ||
11 | |||||||
12 | |||||||
13 | |||||||
14 | Year | 2024 | |||||
15 | Thing Column | 4 | |||||
16 | |||||||
17 | Min | 1/11/2024 | 872 | ||||
18 | |||||||
19 | Max | 12/26/2024 | 607 | ||||
Sheet15 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D17 | D17 | =MIN(FILTER(A2:A10,YEAR(A2:A10)=D14)) |
E17 | E17 | =VLOOKUP(D17,A2:E10,D15+1,FALSE) |
D19 | D19 | =MAX(FILTER(A2:A10,YEAR(A2:A10)=D14)) |
E19 | E19 | =VLOOKUP(D19,A2:E10,D15+1,FALSE) |