Forum Discussion
extract unique values matching a text string
I have two columns (A and B). Column A contains the dates and Column B contains the names of people who are required to attend the duty. Now based on this can i have names of people and just below th...
It was getting late! All that was needed was a TRIM so that the Names row is now given by
= UNIQUE( TRIM(split), 1 )
Please accept may apologies, I came across this discussion and started answering without reading the prior posts with sufficient care. I saw your first post used PQ and assumed the following posts were refinements of the original. I now see that you followed up by exploring formula solutions and had already adopted the use of TEXTJOIN; I will examine your subsequent steps later.