BrianGGG
Board Regular
- Joined
- Mar 5, 2016
- Messages
- 62
Hello. I have seen a few posts that are close to what I am trying to do, but nothing that exactly works in my situation.
Here is my situation: I have two columns in a table (or could be split into two tables) that I would like to combine into a single Named Range so that I can use it as a Drop Down for List Validation in another part of my spreadsheet. Here is an example:
Codelists
<tbody>
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I have two columns above, Regular and Additions. They may or may not have the same number of values (more likely not).
The REGULAR column currently has {a,b,c} and the Additions column has {y,z]
I would like to create a named range that I can use in LIST data validation so that a user would be able to enter
any of the values in either column...in the example this would be a,b,c,y,z.
I have included above something from the forums that has gotten me close, a CHOOSE/TRANSPOSE statement. This combines the arrays, but it makes a two dimensional array rather than a one-dimensional array with all values.
Any ideas how to make the single Dropdown with values from both columns?
Thanks,
BrianGGG
Here is my situation: I have two columns in a table (or could be split into two tables) that I would like to combine into a single Named Range so that I can use it as a Drop Down for List Validation in another part of my spreadsheet. Here is an example:
Codelists
* | N | O |
15 | Regular | Additions |
16 | a | y |
17 | b | z |
18 | c | * |
19 | * | * |
20 | * | * |
21 | #VALUE! | * |
<tbody>
</tbody>
Spreadsheet Formulas | ||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I have two columns above, Regular and Additions. They may or may not have the same number of values (more likely not).
The REGULAR column currently has {a,b,c} and the Additions column has {y,z]
I would like to create a named range that I can use in LIST data validation so that a user would be able to enter
any of the values in either column...in the example this would be a,b,c,y,z.
I have included above something from the forums that has gotten me close, a CHOOSE/TRANSPOSE statement. This combines the arrays, but it makes a two dimensional array rather than a one-dimensional array with all values.
Any ideas how to make the single Dropdown with values from both columns?
Thanks,
BrianGGG