Data Validation in Excel

[miamdjd]

Have a single list of contiguous data and want to choose portions, i.e., non-contiguous cells for data validation list. Use CTRL key to choose, but get error message. Is it possible to do this error-free? There are no empty cells in the source.

[#2]

Please upload a sample spreadsheet. It's hard to picture what you're talking about in any really meaningful manner; the actual would help greatly.