Hello, I would like to ask if it is possible to have a number of drop down depending on the header? What I am trying to do to have a data validation list on row 8 to 10 but only if it contains a header else the cell would be blank/no drop down. The number of headers can increase its count overtime and I also want the number of drop downs to increase overtime as well. is this possible?
| Attrition Rate Report V1.3a.xlsx | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| K | L | M | N | O | P | Q | R | S | |||
| 7 | Variable 1 | Variable 2 | Variable 3 | Variable 4 | |||||||
| 8 | Contractors | ||||||||||
| 9 | Entire Year | ||||||||||
| 10 | 2022 | ||||||||||
Dashboard | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| K7:N7 | K7 | =INDEX('Data Validation and Calculation'!E4#,SEQUENCE(1,Dashboard!I9)) |
| Dynamic array formulas. | ||
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| K8 | List | =OFFSET('Data Validation and Calculation'!$C$4#,0,0,COUNTA('Data Validation and Calculation'!$C$4:$C$1048576)) |
| K9 | List | ='Data Validation and Calculation'!$B$4:$B$8 |
| K10 | List | =OFFSET('Data Validation and Calculation'!D4:D1048576,0,0,COUNTA('Data Validation and Calculation'!D4:D1048576)) |
