Just for further clarification, I am attempting to use the list feature found
in the validation area. The list can be set to a range, or a formula. I would
like a formula that returns only the distinct values of a column, but it must
return them all.

"Chrynoble" wrote:

I am looking for a function, that does not rely on vb code behind the scene,
that will return only the unique values from a column. This function would in
all ways be similar to the "Distinct" function in SQL.