how to put only two options in a dropdown

users
#1

Hi, I have a project that needs a dropdown box
on the data sheet E1 I like the data from B1 and B16
with this i get all $data.$B$1:$B$16
Thanks Beau

#2

Easy: you need to define an intermediate cell range for your drop-down list. Enter =B1 and =B16 in two neighbouring cells in some convenient place and then use the range of those two cells for Source in the Validity panel instead of the original cells. Using references like this instead of copying the original values has the advantage that any changes you later make to the values in B1 or B16 are automatically reflected in the intermediate range.

I trust this helps.

Brian Barker