Hi,
I have a string per cell in one column, such as follows
A1 = open door
A2 = closed door
A3 = closed door
A4 = open door
Now I would like to add a function in a "summary" cell, that shows me unique different values in Range A1:A4. In the example above I would expect the content of the "summary" cell to be "open door, closed door"
Any chance to accomplish this without VBA?
Bookmarks