Hello,
I am being lazy, and want to know if this is possible!
I have a range called 'Data', say 5 Row by 2 Col:
Col1 ------ Col 2
Item 1 ------ 1
Item 2 ------ 2
Item 3 ------ 3
Item 4 ------ 4
Item 5 ------ 5
In my validation cell, I just want {Item 1, Item 2,...., Item 5}, but I am too lazy (or efficient?) to have a second named range. My question is: can I use the two column range 'Data' in the validation reference? It looks like you can have a formula in the source box, or use custom and set a formula.
Any ideas? Thanks for your help.
I am being lazy, and want to know if this is possible!
I have a range called 'Data', say 5 Row by 2 Col:
Col1 ------ Col 2
Item 1 ------ 1
Item 2 ------ 2
Item 3 ------ 3
Item 4 ------ 4
Item 5 ------ 5
In my validation cell, I just want {Item 1, Item 2,...., Item 5}, but I am too lazy (or efficient?) to have a second named range. My question is: can I use the two column range 'Data' in the validation reference? It looks like you can have a formula in the source box, or use custom and set a formula.
Any ideas? Thanks for your help.