Filter logic for multiple value in a cell

CUS ID Fruits Result
7777 Apple (15), Mango (6), Banana(35), Grapes (40), Pine (4) Should come while apply filter
8888 Apple (30), Mango (6), Banana(20), Grapes (40), Pine (4) Not come
9999 Apple (15), Mango (6), Banana(45), Grapes (30), Pine (4) Should come while apply filter
6666 Apple (15), Mango (6), Banana(25), Grapes (50), Pine (4) Not come
     
  FILTER BANANA (>30)  

By: Vinu

Leave a Reply

Your email address will not be published. Required fields are marked *