K
Ken
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
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