I have a list of csv in a single cell, and I need to get the unique values from that list and put them in another cell. For example, in one cell I would have:
DIV-154, FOD-371, UDL-913, DIV-154
And in another cell I would like to get this as output:
DIV-154, FOD-371, UDL-913
I am aware of the Text to Columns and Remove Duplicates functions, but neither of these are quite what I want. Also, this can only be in Function form, it cannot be VBA.
As a closing note, I have searched for an answer to this question to no avail. If it exists somewhere on this site, I apologize and would appreciate a link to that thread.