Thread: Data Validation in Excel

Dear all,

Now I want to have a list data validation for a cell.

The list will get the value from a defined name "testing" which represents a column in another sheet. In the "testing" column, assumes it has below values
a
a
(blank)
(blank)
c
d
...

My concerns are,
1. how to make the cell only display the non-blank value?
2. how to make the cell filter out the duplicated values?

Is there any way to solve the issue without any vba scripts/macros? Thanks in advance.

martindwilson, thanks for your prompt answer.

The problem has resolved.