How would i get this sheet to alternate rows between2 different cell style but link it to where it does not apply if there is no data the column A? the sheet can be anywhere between 2 rows or 4000.
Kane 1.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | PIER # | PILE TYPE | STRUCTURE NAME | LEAD DESCRIPTION | EXTENSION DESCRIPTION | CAP DESCRIPTION | ||
2 | HP-01 | |||||||
3 | HP-02 | |||||||
4 | HP-03 | |||||||
5 | HP-04 | |||||||
6 | HP-05 | |||||||
7 | HP-06 | |||||||
8 | HP-07 | |||||||
9 | HP-08 | |||||||
10 | HP-09 | |||||||
11 | HP-10 | |||||||
12 | HP-11 | |||||||
13 | HP-12 | |||||||
14 | HP-13 | |||||||
15 | HP-14 | |||||||
16 | HP-15 | |||||||
17 | HP-16 | |||||||
18 | HP-17 | |||||||
19 | HP-18 | |||||||
20 | HP-19 | |||||||
21 | HP-20 | |||||||
As-built 1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2:A21 | A2 | ="HP-"&TEXT(SEQUENCE('Input page'!B3),"00") |
D2:D21 | D2 | =FILTER('Input page'!$D$4:$F$9,'Input page'!$C$4:$C$9=$B2,"") |
Dynamic array formulas. |