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...
Hello balaram51,
The format would be slightly different but this formula should get you close to what you are looking for:
In cell D2: =IF(ISNUMBER(SEARCH(D$1,$B2)),$A2,"")
and copy this over and down to K7.
**EDIT: Of course this is assuming that the data that you have given starts at cell A1.
Hope this helps!
PReagan