I want to show 8 weeks of cells consecutively whose sum is the highest in the row.
For example; I have 10 weeks of numbers. I want to show the top 8 weeks that have the highest numbers, consecutively. In the example below, cells C2:J2 would be highlighted.
Thank you in advance
For example; I have 10 weeks of numbers. I want to show the top 8 weeks that have the highest numbers, consecutively. In the example below, cells C2:J2 would be highlighted.
Thank you in advance
Book1.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9 | Week10 | ||
2 | $574,028 | $640,860 | $680,397 | $590,359 | $656,498 | $734,145 | $689,923 | $718,944 | $864,188 | $770,035 | ||
3 | ||||||||||||
4 | ||||||||||||
5 | Sumof1st8weeks | Sumof2nd8weeks | Sumof3rd8weeks | |||||||||
6 | $5,285,154 | $5,575,314 | $5,704,489 | |||||||||
7 | ||||||||||||
8 | Highest8weeks | |||||||||||
9 | $5,704,489 | |||||||||||
10 | ||||||||||||
11 | ||||||||||||
Sheet1 |