SOLVED

List out people who like only a particular fruit

Copper Contributor

Hi,

 

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

 

4 Replies
best response confirmed by Aley1690 (Copper Contributor)
Solution

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

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

 

Screenshot 2020-09-02 at 10.36.39.png

 

Thank you so much! Worked Perfectly @Jan Karel Pieterse 

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

 

 

 fruit.jpg

 

 

1 best response

Accepted Solutions
best response confirmed by Aley1690 (Copper Contributor)
Solution

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

View solution in original post