keelaboosa
New Member
- Joined
- Apr 3, 2018
- Messages
- 35
Is it possible to select a subset of table headers to use as a data validation list in another cell?
I've got the following table named "Notes":
<tbody>
</tbody>
I would like to use all except the first header as a data validation list. I've tried
which evaluates to
but it fails when I try to use the formula as the data validation list.
Is there a way to do this without duplicating the header row as data in another table?
I've got the following table named "Notes":
A | B | C | D | E | F | G | H | I | J | |
1 | NOTES: UNLESS OTHERWISE SPECIFIED | GENERAL ARRANGEMENT | INSTALLATION | ASSEMBLY | CABLE ASSEMBLY | FABRICATION | ALTERED ITEM | SCHEMATIC | PIPING DIAGRAM | VENDOR ITEM |
2 | INTERPRET DRAWING PER ASME Y14.1 | X | X | X | X | X | X | X | X | X |
3 | BREAK SHARP EDGES .005 MAX | X | X | X |
<tbody>
</tbody>
I would like to use all except the first header as a data validation list. I've tried
Code:
=OFFSET(NOTES[#Headers],0,1,1,COUNTA(NOTES[#Headers])-1)
Code:
={"GENERAL ARRANGEMENT","INSTALLATION","ASSEMBLY","CABLE ASSEMBLY","FABRICATION","ALTERED ITEM","SCHEMATIC","PIPING DIAGRAM","VENDOR ITEM"}
Is there a way to do this without duplicating the header row as data in another table?