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...
The approach is basically that outlined by PReagan and Twifoo but I have set out to determine whether dynamic arrays have something to offer here.
The condition that each name is present in the 'persons required' list is
= ISNUMBER( SEARCH( Names, PersonsRequired ) )
This spills to gives a 6x8 Boolean array.
To filter out the unwanted dates for each person, I need to change this formula to apply column by column by using the intersection operator on the names row, giving a final form
= FILTER( date, ISNUMBER( SEARCH( @Names, PersonsRequired ) ) )
Each instance of the formula gives a single dynamically-sized column of dates.