this technically isn't using a formula, but you could use a pivot
table to find the unique values.


On Aug 9, 2:38 pm, Ken wrote:
Excel2003 ... WS2, Col D ... contains Random (often repeating) text ...

Looking for Formula in WS1 Col C that will return "unique" Values only from
WS2 Col D ... (I want no spaces or empty cells) ... Desire results to be
exactly if I had used Advanced Filter ... & then copy/paste.

I desire to do this by Formula instead of Advanced Filter because my data in
WS2 Col D is constantly changing.

Thanks ... Kha