Spreadsheet: 779314d1651691279-max-value-based-on-two-columns-sample_file_050422
Sheet: SAMPLE

[NAME] | YEAR
1 | 2022
1 | 2022
1 | 2022
1 | 2022 |  | DESIRED OUTPUT | 3
1 | 2022 |  | MAX YEAR AND MAX MONTH WITHIN THAT YEAR
1 | 2022
1 | 2022
1 | 2022
1 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
2 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
3 | 2022
1 | 2021
1 | 2021
1 | 2021
1 | 2021
1 | 2021
1 | 2021
1 | 2021
1 | 2021
1 | 2021
2 | 2021
2 | 2021
2 | 2021
2 | 2021
2 | 2021
2 | 2021
2 | 2021
2 | 2021
2 | 2021
3 | 2021
3 | 2021
3 | 2021
3 | 2021
3 | 2021
3 | 2021
3 | 2021
3 | 2021
3 | 2021
3 | 2021
4 | 2021
4 | 2021
4 | 2021
4 | 2021
4 | 2021
4 | 2021
4 | 2021
4 | 2021
4 | 2021
4 | 2021
5 | 2021
5 | 2021
5 | 2021
5 | 2021
5 | 2021
5 | 2021
5 | 2021
5 | 2021
5 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
6 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
7 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
8 | 2021
9 | 2021
9 | 2021
9 | 2021
9 | 2021
9 | 2021
9 | 2021
9 | 2021
9 | 2021
9 | 2021
9 | 2021
10 | 2021
10 | 2021
10 | 2021
10 | 2021
10 | 2021
10 | 2021
10 | 2021
10 | 2021
10 | 2021
11 | 2021
11 | 2021
11 | 2021
11 | 2021
11 | 2021
11 | 2021
11 | 2021
11 | 2021
12 | 2021
12 | 2021
12 | 2021
12 | 2021
12 | 2021
12 | 2021
12 | 2021
12 | 2021
1 | 2020
1 | 2020
1 | 2020
1 | 2020
1 | 2020
1 | 2020
1 | 2020
1 | 2020
2 | 2020
2 | 2020
2 | 2020
2 | 2020
2 | 2020
2 | 2020
2 | 2020
2 | 2020
3 | 2020
3 | 2020
3 | 2020
3 | 2020
3 | 2020
3 | 2020
3 | 2020
3 | 2020
4 | 2020
4 | 2020
4 | 2020
4 | 2020
4 | 2020
4 | 2020
4 | 2020
5 | 2020
5 | 2020
5 | 2020
5 | 2020
5 | 2020
5 | 2020
5 | 2020
6 | 2020
6 | 2020
6 | 2020
6 | 2020
6 | 2020
6 | 2020
6 | 2020
7 | 2020
7 | 2020
7 | 2020
7 | 2020
7 | 2020
7 | 2020
7 | 2020
7 | 2020
8 | 2020
8 | 2020
8 | 2020
8 | 2020
8 | 2020
8 | 2020
8 | 2020
8 | 2020
9 | 2020
9 | 2020
9 | 2020
9 | 2020
9 | 2020
9 | 2020
9 | 2020
9 | 2020
10 | 2020
10 | 2020
10 | 2020
10 | 2020
10 | 2020
10 | 2020
10 | 2020
10 | 2020
11 | 2020
11 | 2020
11 | 2020
11 | 2020
11 | 2020
11 | 2020
11 | 2020
12 | 2020
12 | 2020
12 | 2020
12 | 2020
12 | 2020
12 | 2020
12 | 2020
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
1 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
2 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
3 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
4 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
5 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
6 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
7 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
8 | 2019
9 | 2019
9 | 2019
9 | 2019
9 | 2019
9 | 2019
9 | 2019
9 | 2019
9 | 2019
9 | 2019
9 | 2019
10 | 2019
10 | 2019
10 | 2019
10 | 2019
10 | 2019
10 | 2019
10 | 2019
10 | 2019
11 | 2019
11 | 2019
11 | 2019
11 | 2019
11 | 2019
11 | 2019
11 | 2019
11 | 2019
12 | 2019
12 | 2019
12 | 2019
12 | 2019
12 | 2019
12 | 2019
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
1 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
2 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
3 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
4 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
5 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
6 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
7 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
8 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
9 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
10 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
11 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
12 | 2018
4 | 2017
5 | 2017
6 | 2017
7 | 2017
8 | 2017
9 | 2017
6 | 2017
7 | 2017
8 | 2017
4 | 2017
5 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
6 | 2017
7 | 2017
8 | 2017
9 | 2017
6 | 2017
7 | 2017
8 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
9 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
10 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
11 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017
12 | 2017