Forum Discussion

Copper Contributor

Sep 02, 2020

Solved

List out people who like only a particular fruit

Hi,

I want to know the name(s) of the people who like only a particular fruits. Please help

JKPieterse
Sep 02, 2020
Aley1690 Attached is one way to do it (which only works if you have an Office 365 subscription)
Fruits.xlsx10 KB

Silver Contributor

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))