Spreadsheet: 762743d1641791527-formula-to-get-the-year-of-max-record-with-condition-book1-1-
Sheet: Data

 | Category | Quarter | 2021 | Past Highest Record | Year of Past Highest Record |  |  |  |  |  |  |  |  |  |  | Sales Fiscal Year | Category | [NAME]
 | A | 1Q |  |  | 2010 |  |  |  |  |  |  |  |  |  |  | 2010 | A | 41400
 | B | 1Q |  |  | 2019 |  |  |  |  |  |  |  |  |  |  | 2010 | B | 5600
 | C | 1Q |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 | C | 9300
 | D | 1Q |  |  |  |  | Is there any formula to get this result without using the pivot table below? |  |  |  |  |  |  |  |  | 2010 | D | 10600
 | E | 1Q |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 | E | 7800
 | F | 1Q |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 | F | 6800
 | G | 1Q |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 | G | 3100
 | H | 1Q |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 | H | 7400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010 | I | 6100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | A | 22100
 | Category | Month | 2021 | Past Highest Record | Year of Past Highest Record |  |  |  |  |  |  |  |  |  |  | 2011 | B | 4500
 | A | 3 |  |  | 2018 |  |  |  |  |  |  |  |  |  |  | 2011 | C | 12300
 | B | 3 |  |  | 2020 |  |  |  |  |  |  |  |  |  |  | 2011 | D | 9700
 | C | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | E | 7900
 | D | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | F | 7700
 | E | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | G | 4300
 | F | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | H | 3700
 | G | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 | I | 7000
 | H | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | A | 22500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | B | 6000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | C | 11900
 | Sales Fiscal Quarter | 1Q |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | D | 5800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | E | 8300
 | Sum of Sales | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | F | 11100
 | Row Labels | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | Grand Total |  | 2012 | G | 3300
 | A | 102500 | 58400 | 62000 | 57000 | 69300 | 69400 | 76700 | 90300 | 92900 | 75800 | 60600 | 76200 | 891100 |  | 2012 | H | 5800
 | B | 12500 | 7300 | 12900 | 13400 | 12900 | 10300 | 16900 | 19000 | 21000 | 24400 | 21300 | 18900 | 190800 |  | 2012 | I | 5000
 | C | 26300 | 20600 | 30400 | 51400 | 34600 | 58800 | 45900 | 79600 | 61000 | 55000 | 69500 | 52800 | 585900 |  | 2013 | A | 23300
 | D | 30600 | 17900 | 10800 | 23600 | 16700 | 30300 | 17800 | 36600 | 33400 | 35600 | 39700 | 66300 | 359300 |  | 2013 | B | 4800
 | E | 7400 | 11500 | 9500 | 18500 | 20500 | 26200 | 14800 | 46000 | 43000 | 31100 | 22800 | 25600 | 276900 |  | 2013 | C | 27500
 | F | 20100 | 10600 | 18400 | 16500 | 39500 | 24900 | 36700 | 72900 | 96600 | 74900 | 72800 | 91100 | 575000 |  | 2013 | D | 11600
 | G | 4500 | 7100 | 4700 | 4500 | 4100 | 11200 | 21300 | 33100 | 50000 | 38900 | 25500 | 25500 | 230400 |  | 2013 | E | 10100
 | H | 0 | 200 | 0 | 200 | 1800 | 6300 | 6200 | 14100 | 20900 | 1200 | 12300 | 3600 | 66800 |  | 2013 | F | 8600
 | I | 6100 | 2600 | 4400 | 6500 | 10300 | 16700 | 16400 | 28500 | 32700 | 39700 | 12600 | 14200 | 190700 |  | 2013 | G | 5900
 | Grand Total | 210000 | 136200 | 153100 | 191600 | 209700 | 254100 | 252700 | 420100 | 451500 | 376600 | 337100 | 374200 | 3366900 |  | 2013 | H | 5700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013 | I | 4800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014 | A | 26500
 | Sales Month | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014 | B | 4900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014 | C | 17000
 | Sum of Sales | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014 | D | 7400
 | Row Labels | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | Grand Total |  | 2014 | E | 15100
 | A | 30800 | 20300 | 21200 | 16800 | 19100 | 25200 | 25300 | 32900 | 35700 | 29800 | 23400 | 43000 | 323500 |  | 2014 | F | 14700
 | B | 5000 | 2900 | 4100 | 4800 | 4900 | 4100 | 3800 | 7500 | 7300 | 8100 | 8700 | 8700 | 69900 |  | 2014 | G | 6400
 | C | 7900 | 7200 | 11900 | 9300 | 10600 | 24500 | 13900 | 32000 | 18500 | 16900 | 29000 | 25800 | 207500 |  | 2014 | H | 6900
 | D | 10200 | 3800 | 5800 | 5600 | 4100 | 8400 | 7600 | 14600 | 12200 | 11500 | 11000 | 32300 | 127100 |  | 2014 | I | 7000
 | E | 1400 | 5800 | 2400 | 4700 | 8000 | 13900 | 2700 | 20100 | 12600 | 11900 | 7900 | 16500 | 107900 |  | 2015 | A | 26900
 | F | 6600 | 3500 | 2900 | 3900 | 10200 | 9500 | 12700 | 18200 | 27300 | 31100 | 29400 | 50200 | 205500 |  | 2015 | B | 6200
 | G |  | 4300 | 1500 |  | 2300 | 6300 | 3800 | 9600 | 22100 | 13800 | 2000 | 12200 | 77900 |  | 2015 | C | 24500
 | H | 0 | 100 | 0 | 100 | 1700 | 0 | 3900 | 0 | 8200 | 0 | 5500 | 3500 | 23000 |  | 2015 | D | 12100
 | I | 2300 | 400 | 2200 | 1700 | 2700 | 15200 | 6000 | 13400 | 17000 | 17000 | 7700 | 2500 | 88100 |  | 2015 | E | 13900
 | Grand Total | 64200 | 48300 | 52000 | 46900 | 63600 | 107100 | 79700 | 148300 | 160900 | 140100 | 124600 | 194700 | 1230400 |  | 2015 | F | 14900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015 | G | 6300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015 | H | 6300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015 | I | 15200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | A | 25900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | B | 9100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | C | 20100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | D | 10100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | E | 17000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | F | 23800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | G | 11400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | H | 8400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | I | 7900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | A | 32900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | B | 8700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | C | 32000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | D | 16300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | E | 20100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | F | 27800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | G | 27800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | H | 14100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | I | 14500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | A | 37000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | B | 12000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | C | 24800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | D | 19500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | E | 26300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | F | 36500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | G | 22100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | H | 9100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | I | 17000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | A | 30300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | B | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | C | 35000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | D | 16400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | E | 14200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | F | 31100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | G | 22300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | H | 10200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | I | 18700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | A | 41100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | B | 13400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | C | 29000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | D | 20200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | E | 17500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | F | 31400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | G | 14600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | H | 7400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | I | 12000