Spreadsheet: 679925d1590685966-querying-large-series-of-arrays-and-displaying-unique-values-in-arrays-hard-index-match-excelforum_sample-out-from-data-formation
Sheet: Sheet1

 | DRIVERS |  |  |  |  |  |  |  |  | DESIRED OUTPUT:
 | FY-3 | Yearly |  |  |  |  |  |  | 2017 | FY-17
 | FY-2 | Yearly |  |  |  |  |  |  | 2018 | FY-18
 | FY-1 | Semi-Annually |  |  |  |  |  |  | 2019 | H1-19
 | Current FY: | Quarterly | 2020 |  |  |  |  |  | 2019 | H2-19
 | FY+1 | Monthly | 2021 |  |  |  |  |  | 2020 | Q1-20
 | FY+2 | Yearly | 2021 |  |  |  |  |  | 2020 | Q2-20
 | FY+3 | Yearly | 2021 |  |  |  |  |  | 2020 | Q3-20
 |  |  |  |  |  |  |  |  | 2020 | Q4-20
 |  |  |  |  |  |  |  |  | 2021 | Jan-21
 |  |  |  |  |  |  |  |  | 2021 | Feb-21
 | Monthly Periods Back | Months | Monthly | Quarterly | Semi-Annually | Yearly | Year |  | 2021 | Mar-21
 | 2017-01-31 00:00:00 | 1 | Jan-17 | Q1-17 | H1-17 |  | 2017 |  | 2021 | Apr-21
 | 2017-02-28 00:00:00 | 2 | Feb-17 | Q1-17 | H1-17 |  | 2017 |  | 2021 | May-21
 | 2017-03-31 00:00:00 | 3 | Mar-17 | Q1-17 | H1-17 |  | 2017 |  | 2021 | [NAME]
 | 2017-04-30 00:00:00 | 4 | Apr-17 | Q2-17 | H1-17 |  | 2017 |  | 2021 | [NAME]
 | 2017-05-31 00:00:00 | 5 | May-17 | Q2-17 | H1-17 |  | 2017 |  | 2021 | Aug-21
 | 2017-06-30 00:00:00 | 6 | Jun-17 | Q2-17 | H1-17 |  | 2017 |  | 2021 | Sep-21
 | 2017-07-31 00:00:00 | 7 | Jul-17 | Q3-17 | H2-17 |  | 2017 |  | 2021 | Oct-21
 | 2017-08-31 00:00:00 | 8 | Aug-17 | Q3-17 | H2-17 |  | 2017 |  | 2021 | Nov-21
 | 2017-09-30 00:00:00 | 9 | Sep-17 | Q3-17 | H2-17 |  | 2017 |  | 2021 | Dec-21
 | 2017-10-31 00:00:00 | 10 | Oct-17 | Q4-17 | H2-17 |  | 2017 |  | 2022 | FY-22
 | 2017-11-30 00:00:00 | 11 | Nov-17 | Q4-17 | H2-17 |  | 2017 |  | 2023 | FY-23
 | 2017-12-31 00:00:00 | 12 | Dec-17 | Q4-17 | H2-17 |  | 2017
 | 2018-01-31 00:00:00 | 1 | Jan-18 | Q1-18 | H1-18 |  | 2018
 | 2018-02-28 00:00:00 | 2 | Feb-18 | Q1-18 | H1-18 |  | 2018
 | 2018-03-31 00:00:00 | 3 | Mar-18 | Q1-18 | H1-18 |  | 2018
 | 2018-04-30 00:00:00 | 4 | Apr-18 | Q2-18 | H1-18 |  | 2018
 | 2018-05-31 00:00:00 | 5 | May-18 | Q2-18 | H1-18 |  | 2018
 | 2018-06-30 00:00:00 | 6 | Jun-18 | Q2-18 | H1-18 |  | 2018
 | 2018-07-31 00:00:00 | 7 | Jul-18 | Q3-18 | H2-18 |  | 2018
 | 2018-08-31 00:00:00 | 8 | Aug-18 | Q3-18 | H2-18 |  | 2018
 | 2018-09-30 00:00:00 | 9 | Sep-18 | Q3-18 | H2-18 |  | 2018
 | 2018-10-31 00:00:00 | 10 | Oct-18 | Q4-18 | H2-18 |  | 2018
 | 2018-11-30 00:00:00 | 11 | Nov-18 | Q4-18 | H2-18 |  | 2018
 | 2018-12-31 00:00:00 | 12 | Dec-18 | Q4-18 | H2-18 |  | 2018
 | 2019-01-31 00:00:00 | 1 | Jan-19 | Q1-19 | H1-19 |  | 2019
 | 2019-02-28 00:00:00 | 2 | Feb-19 | Q1-19 | H1-19 |  | 2019
 | 2019-03-31 00:00:00 | 3 | Mar-19 | Q1-19 | H1-19 |  | 2019
 | 2019-04-30 00:00:00 | 4 | Apr-19 | Q2-19 | H1-19 |  | 2019
 | 2019-05-31 00:00:00 | 5 | May-19 | Q2-19 | H1-19 |  | 2019
 | 2019-06-30 00:00:00 | 6 | Jun-19 | Q2-19 | H1-19 |  | 2019
 | 2019-07-31 00:00:00 | 7 | Jul-19 | Q3-19 | H2-19 |  | 2019
 | 2019-08-31 00:00:00 | 8 | Aug-19 | Q3-19 | H2-19 |  | 2019
 | 2019-09-30 00:00:00 | 9 | Sep-19 | Q3-19 | H2-19 |  | 2019
 | 2019-10-31 00:00:00 | 10 | Oct-19 | Q4-19 | H2-19 |  | 2019
 | 2019-11-30 00:00:00 | 11 | Nov-19 | Q4-19 | H2-19 |  | 2019
 | 2019-12-31 00:00:00 | 12 | Dec-19 | Q4-19 | H2-19 |  | 2019
 | 2020-01-31 00:00:00 | 1 | Jan-20 | Q1-20 | H1-20 |  | 2020
 | 2020-02-29 00:00:00 | 2 | Feb-20 | Q1-20 | H1-20 |  | 2020
 | 2020-03-31 00:00:00 | 3 | Mar-20 | Q1-20 | H1-20 |  | 2020
 | 2020-04-30 00:00:00 | 4 | Apr-20 | Q2-20 | H1-20 |  | 2020
 | 2020-05-31 00:00:00 | 5 | May-20 | Q2-20 | H1-20 |  | 2020
 | 2020-06-30 00:00:00 | 6 | Jun-20 | Q2-20 | H1-20 |  | 2020
 | 2020-07-31 00:00:00 | 7 | [NAME] | Q3-20 | H2-20 |  | 2020
 | 2020-08-31 00:00:00 | 8 | Aug-20 | Q3-20 | H2-20 |  | 2020
 | 2020-09-30 00:00:00 | 9 | Sep-20 | Q3-20 | H2-20 |  | 2020
 | 2020-10-31 00:00:00 | 10 | Oct-20 | Q4-20 | H2-20 |  | 2020
 | 2020-11-30 00:00:00 | 11 | Nov-20 | Q4-20 | H2-20 |  | 2020
 | 2020-12-31 00:00:00 | 12 | Dec-20 | Q4-20 | H2-20 |  | 2020
 | 2021-01-31 00:00:00 | 1 | Jan-21 | Q1-21 | H1-21 |  | 2021
 | 2021-02-28 00:00:00 | 2 | Feb-21 | Q1-21 | H1-21 |  | 2021
 | 2021-03-31 00:00:00 | 3 | Mar-21 | Q1-21 | H1-21 |  | 2021
 | 2021-04-30 00:00:00 | 4 | Apr-21 | Q2-21 | H1-21 |  | 2021
 | 2021-05-31 00:00:00 | 5 | May-21 | Q2-21 | H1-21 |  | 2021
 | 2021-06-30 00:00:00 | 6 | [NAME] | Q2-21 | H1-21 |  | 2021
 | 2021-07-31 00:00:00 | 7 | [NAME] | Q3-21 | H2-21 |  | 2021
 | 2021-08-31 00:00:00 | 8 | Aug-21 | Q3-21 | H2-21 |  | 2021
 | 2021-09-30 00:00:00 | 9 | Sep-21 | Q3-21 | H2-21 |  | 2021
 | 2021-10-31 00:00:00 | 10 | Oct-21 | Q4-21 | H2-21 |  | 2021
 | 2021-11-30 00:00:00 | 11 | Nov-21 | Q4-21 | H2-21 |  | 2021
 | 2021-12-31 00:00:00 | 12 | Dec-21 | Q4-21 | H2-21 |  | 2021
 | 2022-01-31 00:00:00 | 1 | Jan-22 | Q1-22 | H1-22 |  | 2022
 | 2022-02-28 00:00:00 | 2 | Feb-22 | Q1-22 | H1-22 |  | 2022
 | 2022-03-31 00:00:00 | 3 | Mar-22 | Q1-22 | H1-22 |  | 2022
 | 2022-04-30 00:00:00 | 4 | Apr-22 | Q2-22 | H1-22 |  | 2022
 | 2022-05-31 00:00:00 | 5 | May-22 | Q2-22 | H1-22 |  | 2022
 | 2022-06-30 00:00:00 | 6 | Jun-22 | Q2-22 | H1-22 |  | 2022
 | 2022-07-31 00:00:00 | 7 | Jul-22 | Q3-22 | H2-22 |  | 2022
 | 2022-08-31 00:00:00 | 8 | Aug-22 | Q3-22 | H2-22 |  | 2022
 | 2022-09-30 00:00:00 | 9 | Sep-22 | Q3-22 | H2-22 |  | 2022
 | 2022-10-31 00:00:00 | 10 | Oct-22 | Q4-22 | H2-22 |  | 2022
 | 2022-11-30 00:00:00 | 11 | Nov-22 | Q4-22 | H2-22 |  | 2022
 | 2022-12-31 00:00:00 | 12 | Dec-22 | Q4-22 | H2-22 |  | 2022
 | 2023-01-31 00:00:00 | 1 | Jan-23 | Q1-23 | H1-23 |  | 2023
 | 2023-02-28 00:00:00 | 2 | Feb-23 | Q1-23 | H1-23 |  | 2023
 | 2023-03-31 00:00:00 | 3 | Mar-23 | Q1-23 | H1-23 |  | 2023
 | 2023-04-30 00:00:00 | 4 | Apr-23 | Q2-23 | H1-23 |  | 2023
 | 2023-05-31 00:00:00 | 5 | May-23 | Q2-23 | H1-23 |  | 2023
 | 2023-06-30 00:00:00 | 6 | Jun-23 | Q2-23 | H1-23 |  | 2023
 | 2023-07-31 00:00:00 | 7 | Jul-23 | Q3-23 | H2-23 |  | 2023
 | 2023-08-31 00:00:00 | 8 | Aug-23 | Q3-23 | H2-23 |  | 2023
 | 2023-09-30 00:00:00 | 9 | Sep-23 | Q3-23 | H2-23 |  | 2023
 | 2023-10-31 00:00:00 | 10 | Oct-23 | Q4-23 | H2-23 |  | 2023
 | 2023-11-30 00:00:00 | 11 | Nov-23 | Q4-23 | H2-23 |  | 2023
 | 2023-12-31 00:00:00 | 12 | Dec-23 | Q4-23 | H2-23 |  | 2023