List out people who like only a particular fruit

[Aley1690]

Hi,

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

[#2 · Accepted solution]

@Aley1690 Attached is one way to do it (which only works if you have an Office 365 subscription)

[#3]

@Aley1690 As a variant, filtering "people who only like one particular fruit".

[#4]

Thank you so much! Worked Perfectly @Jan Karel Pieterse 

[#5]

@Aley1690 

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