Hello,
Hoping for a solution to my challenge. I am trying to automatically format the sequence so that it starts at 1 and increased by 1 on sheet 2 to a max number of cell K19 on a sheet 1. Where it becomes a little more complex is I was hoping to have the sequence start in F5 on delivery schedule start at 1 go to 5 columns then drop down to F16 and resume the sequence till the max number is met from K19 on user input. I would always like it to have 5 columns for each level of sequence if that makes sense. Thanks in advance
Hoping for a solution to my challenge. I am trying to automatically format the sequence so that it starts at 1 and increased by 1 on sheet 2 to a max number of cell K19 on a sheet 1. Where it becomes a little more complex is I was hoping to have the sequence start in F5 on delivery schedule start at 1 go to 5 columns then drop down to F16 and resume the sequence till the max number is met from K19 on user input. I would always like it to have 5 columns for each level of sequence if that makes sense. Thanks in advance
load list prototype Working.xlsx | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
5 | Summary | QTY | Unit | Size | Notes/Vendor | Delivery #1 | Delivery #2 | Delivery #3 | Delivery #4 | Delivery #5 | Delivery #6 | Delivery #7 | Delivery #8 | Delivery #9 | Delivery #10 | Delivery #11 | Delivery #12 | Delivery #13 | ||
6 | Pressure Treated Wood | 2,600 | LF | 2x | ||||||||||||||||
7 | Pressure Treated Wood - w/ shim | 510 | LF | 2x | ||||||||||||||||
8 | Roof Hatch | 1 | EA | 30"x96"x5.25" | ||||||||||||||||
9 | Sumps | 10 | EA | 8x8 | ||||||||||||||||
10 | Crickets | 5 | EA | |||||||||||||||||
11 | Expansion Joint - Backer Rod | 510 | LF | |||||||||||||||||
12 | Expansion Joint - Batt Insulation | 510 | LF | |||||||||||||||||
13 | Expansion Joint - EPDM | 510 | LF | |||||||||||||||||
14 | Froth Pak | 15 | EA | |||||||||||||||||
Delivery Schedule |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A5:E14 | A5 | =IF(FILTER('User Input '!M31:Q43,'User Input '!N31:N43>0)=0,"",FILTER('User Input '!M31:Q43,'User Input '!N31:N43>0)) |
F5:R5 | F5 | =IFERROR("Delivery #"&SEQUENCE(,'User Input '!K19,1,1),"") |
Dynamic array formulas. |