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