YahooGoogle
New Member
- Joined
- Nov 7, 2017
- Messages
- 14
- Office Version
- 2007
Hello, I have inlcuded an example chart that I use regularly for work below (assuming it starts in cell A1 - so data range would be B2:AH34). Is there a way to find the max value of this chart, or even the top 5 max values (would be ideal but will settle for just one max figure for now if it's not possible)? I have tried numerous things but it seems that the empty cells and/or the #DIV/0! cells are causing issues for me. Also, is there a way to have a separate cell next to the max number that references the actual cell that this max value is found (to save me time from having to look through each cell individually until I find that max number the formula spits out)?
Thank you in advance
Thank you in advance
Days | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 |
3 | 101.5% | ||||||||||||||||||||||||||||||||
4 | 76.5% | 91.0% | |||||||||||||||||||||||||||||||
5 | 49.2% | 58.6% | 110.2% | ||||||||||||||||||||||||||||||
6 | 53.8% | 64.0% | 120.3% | 122.4% | |||||||||||||||||||||||||||||
7 | 61.4% | 73.0% | 137.3% | 139.7% | 162.0% | ||||||||||||||||||||||||||||
8 | 62.1% | 73.9% | 139.0% | 141.4% | 164.0% | 113.9% | |||||||||||||||||||||||||||
9 | 75.8% | 90.1% | 169.5% | 172.4% | 200.0% | 138.9% | 149.3% | ||||||||||||||||||||||||||
10 | 56.8% | 67.6% | 127.1% | 129.3% | 150.0% | 104.2% | 111.9% | 83.3% | |||||||||||||||||||||||||
11 | 58.3% | 69.4% | 130.5% | 132.8% | 154.0% | 106.9% | 114.9% | 85.6% | 110.0% | ||||||||||||||||||||||||
12 | 98.5% | 117.1% | 220.3% | 224.1% | 260.0% | 180.6% | 194.0% | 144.4% | 185.7% | 240.7% | |||||||||||||||||||||||
13 | 85.6% | 101.8% | 191.5% | 194.8% | 226.0% | 156.9% | 168.7% | 125.6% | 161.4% | 209.3% | 166.2% | ||||||||||||||||||||||
14 | 68.2% | 81.1% | 152.5% | 155.2% | 180.0% | 125.0% | 134.3% | 100.0% | 128.6% | 166.7% | 132.4% | 100.0% | |||||||||||||||||||||
15 | 66.7% | 79.3% | 149.2% | 151.7% | 176.0% | 122.2% | 131.3% | 97.8% | 125.7% | 163.0% | 129.4% | 97.8% | 123.9% | ||||||||||||||||||||
16 | 41.7% | 49.5% | 93.2% | 94.8% | 110.0% | 76.4% | 82.1% | 61.1% | 78.6% | 101.9% | 80.9% | 61.1% | 77.5% | 84.6% | |||||||||||||||||||
17 | 38.6% | 45.9% | 86.4% | 87.9% | 102.0% | 70.8% | 76.1% | 56.7% | 72.9% | 94.4% | 75.0% | 56.7% | 71.8% | 78.5% | 102.0% | ||||||||||||||||||
18 | 28.0% | 33.3% | 62.7% | 63.8% | 74.0% | 51.4% | 55.2% | 41.1% | 52.9% | 68.5% | 54.4% | 41.1% | 52.1% | 56.9% | 74.0% | 92.5% | |||||||||||||||||
19 | 23.5% | 27.9% | 52.5% | 53.4% | 62.0% | 43.1% | 46.3% | 34.4% | 44.3% | 57.4% | 45.6% | 34.4% | 43.7% | 47.7% | 62.0% | 77.5% | 103.3% | ||||||||||||||||
20 | 18.9% | 22.5% | 42.4% | 43.1% | 50.0% | 34.7% | 37.3% | 27.8% | 35.7% | 46.3% | 36.8% | 27.8% | 35.2% | 38.5% | 50.0% | 62.5% | 83.3% | 104.2% | |||||||||||||||
21 | 13.6% | 16.2% | 30.5% | 31.0% | 36.0% | 25.0% | 26.9% | 20.0% | 25.7% | 33.3% | 26.5% | 20.0% | 25.4% | 27.7% | 36.0% | 45.0% | 60.0% | 75.0% | 72.0% | ||||||||||||||
22 | 30.3% | 36.0% | 67.8% | 69.0% | 80.0% | 55.6% | 59.7% | 44.4% | 57.1% | 74.1% | 58.8% | 44.4% | 56.3% | 61.5% | 80.0% | 100.0% | 133.3% | 166.7% | 160.0% | 250.0% | |||||||||||||
23 | 61.4% | 73.0% | 137.3% | 139.7% | 162.0% | 112.5% | 120.9% | 90.0% | 115.7% | 150.0% | 119.1% | 90.0% | 114.1% | 124.6% | 162.0% | 202.5% | 270.0% | 337.5% | 324.0% | 506.3% | 289.3% | ||||||||||||
24 | 56.1% | 66.7% | 125.4% | 127.6% | 148.0% | 102.8% | 110.4% | 82.2% | 105.7% | 137.0% | 108.8% | 82.2% | 104.2% | 113.8% | 148.0% | 185.0% | 246.7% | 308.3% | 296.0% | 462.5% | 264.3% | 137.0% | |||||||||||
25 | 17.4% | 20.7% | 39.0% | 39.7% | 46.0% | 31.9% | 34.3% | 25.6% | 32.9% | 42.6% | 33.8% | 25.6% | 32.4% | 35.4% | 46.0% | 57.5% | 76.7% | 95.8% | 92.0% | 143.8% | 82.1% | 42.6% | 38.3% | ||||||||||
26 | 18.9% | 22.5% | 42.4% | 43.1% | 50.0% | 34.7% | 37.3% | 27.8% | 35.7% | 46.3% | 36.8% | 27.8% | 35.2% | 38.5% | 50.0% | 62.5% | 83.3% | 104.2% | 100.0% | 156.3% | 89.3% | 46.3% | 41.7% | 277.8% | |||||||||
27 | 49.2% | 58.6% | 110.2% | 112.1% | 130.0% | 90.3% | 97.0% | 72.2% | 92.9% | 120.4% | 95.6% | 72.2% | 91.5% | 100.0% | 130.0% | 162.5% | 216.7% | 270.8% | 260.0% | 406.3% | 232.1% | 120.4% | 108.3% | 722.2% | 406.3% | ||||||||
28 | 7.6% | 9.0% | 16.9% | 17.2% | 20.0% | 13.9% | 14.9% | 11.1% | 14.3% | 18.5% | 14.7% | 11.1% | 14.1% | 15.4% | 20.0% | 25.0% | 33.3% | 41.7% | 40.0% | 62.5% | 35.7% | 18.5% | 16.7% | 111.1% | 62.5% | 45.5% | |||||||
29 | 3.8% | 4.5% | 8.5% | 8.6% | 10.0% | 6.9% | 7.5% | 5.6% | 7.1% | 9.3% | 7.4% | 5.6% | 7.0% | 7.7% | 10.0% | 12.5% | 16.7% | 20.8% | 20.0% | 31.3% | 17.9% | 9.3% | 8.3% | 55.6% | 31.3% | 22.7% | 71.4% | ||||||
30 | 3.0% | 3.6% | 6.8% | 6.9% | 8.0% | 5.6% | 6.0% | 4.4% | 5.7% | 7.4% | 5.9% | 4.4% | 5.6% | 6.2% | 8.0% | 10.0% | 13.3% | 16.7% | 16.0% | 25.0% | 14.3% | 7.4% | 6.7% | 44.4% | 25.0% | 18.2% | 57.1% | 400.0% | |||||
31 | 1.5% | 1.8% | 3.4% | 3.4% | 4.0% | 2.8% | 3.0% | 2.2% | 2.9% | 3.7% | 2.9% | 2.2% | 2.8% | 3.1% | 4.0% | 5.0% | 6.7% | 8.3% | 8.0% | 12.5% | 7.1% | 3.7% | 3.3% | 22.2% | 12.5% | 9.1% | 28.6% | 200.0% | 50.0% | ||||
32 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||
33 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||
34 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |
35 | 0.8% | 0.9% | 1.7% | 1.7% | 2.0% | 1.4% | 1.5% | 1.1% | 1.4% | 1.9% | 1.5% | 1.1% | 1.4% | 1.5% | 2.0% | 2.5% | 3.3% | 4.2% | 4.0% | 6.3% | 3.6% | 1.9% | 1.7% | 11.1% | 6.3% | 4.5% | 14.3% | 100.0% | 25.0% | 100.0% | #DIV/0! | #DIV/0! | #DIV/0! |