Spreadsheet: 885168d1734602159-filter-formula-with-a-dynamic-array-as-part-of-the-condition-filter-formel
Sheet: Tabelle1

 | NAME | MONTHS |  | NAME |  |  | 2020 | 2021 | 2022 |  |  |  |  | 2020 | 2021 | 2022
 | AAA | Dez 2019 | Jan 2020 | Feb 2020 | Apr 2020 | Mai 2020 | Jul 2020 | Aug 2020 | Sep 2020 | Okt 2020 | Nov 2020 | Dez 2020 | Jan 2021 | Jan 2022 | Feb 2022 | Apr 2022 | Mai 2022 | [NAME] | Jul 2022 | Sep 2022 | Feb 2021 | Mrz 2021 | Apr 2021 | Mai 2021 | [NAME] | Jul 2021 | Aug 2021 | Sep 2021 | Okt 2021 | Nov 2021 | Dez 2021 | Dez 2022 | Okt 2022 | Aug 2022 | Nov 2022 |  | AAA
 | BBB | Feb 2020 | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 | [NAME] | Sep 2022 | Nov 2022 | Mai 2021 | Jul 2021 | Nov 2021 | Dez 2021 | Feb 2023 | Mrz 2023 | Apr 2023 | Aug 2023 |  |  |  |  | 2020-02-01 00:00:00 | 2021-02-01 00:00:00 | 2022-02-01 00:00:00
 | CCC | Jun 2020 | Jul 2020 | Sep 2020 | Okt 2020 | Nov 2020 | Dez 2020 | Jan 2021 | Apr 2021 | Mai 2021 | Aug 2021 | Sep 2021 |  | MONTH |  |  | 2020-04-01 00:00:00 | 2021-03-01 00:00:00 | 2022-04-01 00:00:00
 | DDD | Sep 2020 | Okt 2020 | Nov 2020 | Dez 2020 | Jan 2021 | Mrz 2021 | Apr 2021 | Mai 2021 | [NAME] | Jul 2021 | Aug 2021 |  |  |  |  | 2020-05-01 00:00:00 | 2021-04-01 00:00:00 | 2022-05-01 00:00:00
 | EEE | Jan 2022 | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 | [NAME] | Jul 2022 | Mai 2021 | [NAME] | Jul 2021 | Aug 2021 | Sep 2021 | Okt 2021 | Nov 2021 | Dez 2021 | Jan 2024 | Feb 2024 | Mrz 2024 | Apr 2024 | Mai 2024 |  | 2020-01-01 00:00:00 |  |  | 2020-07-01 00:00:00 | 2021-05-01 00:00:00 | 2022-06-01 00:00:00
 | FFF | Jan 2022 | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 | Jul 2022 | [NAME] | Aug 2022 | Sep 2022 | Okt 2022 | Nov 2022 | Dez 2022 | Jan 2023 | Feb 2023 |  | 2020-02-01 00:00:00 |  |  | 2020-08-01 00:00:00 | 2021-06-01 00:00:00 | 2022-07-01 00:00:00
 | GGG | Jan 2022 | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 | Jul 2022 | Sep 2022 | Nov 2022 | Mai 2021 | [NAME] | Jul 2021 | Aug 2021 | Sep 2021 | Okt 2021 | Nov 2021 | Dez 2021 | Dez 2022 | Jan 2023 | Feb 2023 | Mrz 2023 | Apr 2023 | Mai 2023 | Aug 2023 | Sep 2023 | Nov 2023 | Dez 2023 | Jan 2024 | Feb 2024 |  | 2020-04-01 00:00:00 |  |  | 2020-09-01 00:00:00 | 2021-07-01 00:00:00 | 2022-08-01 00:00:00
 | HHH | Jan 2022 | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 | [NAME] | Jul 2022 |  | 2020-05-01 00:00:00 |  |  | 2020-10-01 00:00:00 | 2021-08-01 00:00:00 | 2022-09-01 00:00:00
 | III | Jan 2022 | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 | [NAME] | Jul 2022 | Aug 2022 | Sep 2022 | Okt 2022 | Nov 2022 | Jun 2021 | Jul 2021 | Aug 2021 | Sep 2021 | Okt 2021 | Nov 2021 | Dez 2021 | Dez 2022 | Jan 2023 | Feb 2023 | Mrz 2023 | Apr 2023 |  | 2020-07-01 00:00:00 |  |  | 2020-11-01 00:00:00 | 2021-09-01 00:00:00 | 2022-10-01 00:00:00
 | JJJ | Mrz 2022 |  | 2020-08-01 00:00:00 |  |  | 2020-12-01 00:00:00 | 2021-10-01 00:00:00 | 2022-11-01 00:00:00
 | KKK | Mrz 2022 | Mai 2022 |  | 2020-09-01 00:00:00 |  |  |  | 2021-11-01 00:00:00 | 2022-12-01 00:00:00
 | LLL | Mrz 2022 | Mai 2022 | Jul 2022 |  | 2020-10-01 00:00:00 |  |  |  | 2021-12-01 00:00:00
 | MMM | Mai 2021 | [NAME] | Jul 2021 |  | 2020-11-01 00:00:00
 | NNN | Mai 2021 | [NAME] | Jul 2021 | Nov 2021 | Okt 2021 |  | 2020-12-01 00:00:00
 | OOO | Jun 2021 |  | 2021-01-01 00:00:00 |  | FORMULA IN G3
 | PPP | Feb 2023 | Jan 2023 | Mrz 2024 |  | 2021-02-01 00:00:00
 | QQQ | Jan 2023 | Feb 2023 |  | 2021-03-01 00:00:00
 | RRR | Feb 2023 | Jan 2023 | Sep 2022 |  | 2021-04-01 00:00:00 |  | FORMULA IN N3
 | SSS | Feb 2024 | Mrz 2024 |  | 2021-05-01 00:00:00 |  | =FILTER($E$6#;JAHR($E$6#) = G2#;"")
 | TTT | Mrz 2021 | [NAME] | Jul 2021 | Aug 2021 | Sep 2021 | Dez 2021 |  | 2021-06-01 00:00:00
 | UUU | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 |  | 2021-07-01 00:00:00
 | VVV | Feb 2022 | Mrz 2022 | Apr 2022 | Mai 2022 | Jul 2022 |  | 2021-08-01 00:00:00
 | WWW | Mrz 2022 | Apr 2022 | Mai 2022 | Jul 2022 |  | 2021-09-01 00:00:00
 | [NAME] | Aug 2022 | Jul 2022 | Sep 2022 | Okt 2022 | Nov 2022 | Dez 2022 |  | 2021-10-01 00:00:00
 |  |  |  | 2021-11-01 00:00:00
 |  |  |  | 2021-12-01 00:00:00
 |  |  |  | 2022-01-01 00:00:00
 |  |  |  | 2022-02-01 00:00:00
 |  |  |  | 2022-04-01 00:00:00
 |  |  |  | 2022-05-01 00:00:00
 |  |  |  | 2022-06-01 00:00:00
 |  |  |  | 2022-07-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00
 |  |  |  | 2022-09-01 00:00:00
 |  |  |  | 2022-10-01 00:00:00
 |  |  |  | 2022-11-01 00:00:00
 |  |  |  | 2022-12-01 00:00:00