LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
Hi All
i have this data
in range A2:M14
and i get the highest Sales From This Table by Function Large
my Question
how i can get the name of month and year From Each one of this Values
the result for first line
98957.46 Yeas is 2011 Month Aug
i need formula to do that without Changing Data layout
i have this data
2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | |
Jan | 45,149.60 | 76,249.86 | 72,412.60 | 23,409.26 | 83,908.23 | 82,724.74 | 49,913.37 | 70,728.86 | 4,416.54 | 61,071.23 | 22,704.21 | 76,804.66 |
Feb | 30,555.36 | 73,104.39 | 57,297.66 | 89,688.13 | 50,165.71 | 60,077.21 | 13,531.12 | 49,570.29 | 59,496.03 | 8,921.62 | 92,197.73 | 67,460.36 |
Mar | 21,608.99 | 36,339.27 | 21,235.38 | 52,418.65 | 61,033.78 | 50,561.46 | 78,225.45 | 31,191.93 | 91,151.37 | 91,178.09 | 74,800.71 | 80,748.89 |
Apr | 81,801.81 | 35,501.58 | 29,073.81 | 45,339.68 | 34,752.21 | 23,995.73 | 12,659.20 | 4,947.22 | 67,160.00 | 55,131.82 | 15,710.53 | 15,579.69 |
May | 12,199.39 | 78,509.38 | 31,039.96 | 77,098.36 | 21,619.35 | 32,470.22 | 49,348.30 | 65,940.48 | 5,120.67 | 36,043.77 | 5,838.33 | 92,043.66 |
Jun | 12,661.03 | 45,782.26 | 21,403.17 | 51,664.34 | 54,511.89 | 94,633.87 | 12,896.98 | 93,584.13 | 12,803.14 | 63,584.26 | 80,878.97 | 35,968.93 |
Jul | 65,555.15 | 97,417.43 | 54,882.24 | 44,430.13 | 36,346.93 | 66,670.34 | 78,241.86 | 65,785.69 | 28,351.80 | 29,499.59 | 91,120.24 | 79,486.58 |
Aug | 90,536.96 | 98,957.46 | 44,090.10 | 66,568.31 | 2,656.73 | 87,136.34 | 49,877.47 | 74,783.41 | 57,351.77 | 38,779.90 | 57,660.81 | 66,435.26 |
Sep | 12,839.83 | 91,225.23 | 48,399.98 | 54,662.50 | 6,512.15 | 20,346.65 | 75,301.21 | 67,279.38 | 79,972.44 | 81,113.93 | 12,086.08 | 35,788.94 |
Oct | 30,006.08 | 67,379.42 | 64,291.48 | 24,467.70 | 98,809.45 | 68,517.80 | 67,606.99 | 69,920.49 | 80,764.32 | 88,669.03 | 20,104.29 | 23,344.84 |
Nov | 94,846.19 | 55,164.55 | 55,159.90 | 73,427.91 | 66,821.75 | 44,138.21 | 14,348.50 | 71,831.44 | 86,411.27 | 32,776.46 | 80,330.05 | 82,913.78 |
Dec | 61,213.79 | 82,239.09 | 54,829.66 | 19,752.35 | 86,381.06 | 40,036.52 | 11,423.66 | 3,042.42 | 37,248.81 | 47,619.12 | 88,888.41 | 85,887.80 |
in range A2:M14
and i get the highest Sales From This Table by Function Large
highest sales | Year | Month |
98,957.46 | ||
98,809.45 | ||
97,417.43 | ||
94,846.19 | ||
94,633.87 | ||
93,584.13 |
how i can get the name of month and year From Each one of this Values
the result for first line
98957.46 Yeas is 2011 Month Aug
i need formula to do that without Changing Data layout