graemestown
New Member
- Joined
- May 10, 2019
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
https://www.dropbox.com/s/amwx4p2ofoau8w3/Example.xlsx?dl=0
<colgroup><col width="64" style="width:48pt"> <col width="64" span="20" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="20" style="width:48pt"></colgroup><tbody></tbody>
1 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U |
2 | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | Week | ||
3 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | ||
4 | Bread | 969 | 883 | 638 | 494 | 112 | 750 | 683 | 986 | 273 | 390 | 993 | 566 | 465 | 127 | =Formula | |||||
5 | Cake | 320 | 508 | 306 | 833 | 100 | 361 | 53 | 364 | 323 | 844 | 873 | 113 | 575 | 963 | 415 | 66 | 557 | =Formula | ||
6 | Pies | 320 | 720 | 480 | 574 | 203 | 607 | 54 | 900 | 796 | 807 | 774 | =Formula | ||||||||
7 | Rolls | 602 | 404 | 801 | 340 | 977 | 767 | 583 | 933 | 731 | 285 | 335 | 833 | 462 | 858 | 872 | 360 | 932 | =Formula | ||
8 | Donuts | 12 | 16 | 20 | 23 | 92 | 121 | 717 | 523 | 105 | 180 | 263 | 98 | 923 | 138 | 470 | 516 | 460 | 518 | 266 | =Formula |
Criteria for formula: | |||||||||||||||||||||
1 | Ignores blank cells and allows for an 'if greater than' statement. For example it ignores all the bold cells because they are less than 50 | ||||||||||||||||||||
2 | Then counts 8 cells from the start of the valid sequence | ||||||||||||||||||||
3 | Formula returns the value in the 8th cell, the result I want returned is italic & underlined | ||||||||||||||||||||
4 | Formula would be in column u which I could drag down and would work regardless of where the sequence starts |
<colgroup><col width="64" style="width:48pt"> <col width="64" span="20" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="20" style="width:48pt"></colgroup><tbody></tbody>