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.

There's no function that could be used in cell formulas, but Advanced
Filters (Data Filter Advanced) includes what it calls 'unique
values only'.