Sep 02 2020 12:49 AM
Hi,
I want to know the name(s) of the people who like only a particular fruits. Please help
Sep 02 2020 01:25 AM
Solution@Aley1690 Attached is one way to do it (which only works if you have an Office 365 subscription)
Sep 02 2020 01:37 AM - edited Sep 02 2020 01:42 AM
Sep 06 2020 10:43 PM
Thank you so much! Worked Perfectly @Jan Karel Pieterse
Sep 07 2020 03:29 AM
TEXTJOIN can also be useful for filtering null returns. Basic form
= TEXTJOIN(", ",1,IF(ISNUMBER(FIND([@Fruits],Fruits)), Name,""))
or with a full set of 365 go-faster stripes
= LET(
SelectedNames, IF(ISNUMBER(FIND([@Fruits],Fruits)), Name,""),
SortedNames, SORT(SelectedNames),
TEXTJOIN(", ", 1, SortedNames))
Sep 02 2020 01:25 AM
Solution@Aley1690 Attached is one way to do it (which only works if you have an Office 365 subscription)