8 Replies Latest reply on Aug 16, 2018 7:30 AM by Chike Ckuks

    If Statement on Different Category

    Chike Ckuks

      Hello Everyone, please I was wondering if someone could help in attaining this for me. I have to categories A and B. Category A= Fruit, Vegetables, People while Category B= Apple, Orange, Mango, Pine Apple, Spinach, Man, Woman, Tomatoes.

      I am trying to create a If Statement whereby I want only Orange and Apple to go under Fruit in Category A. Fruit= Apple and Orange in a single column. Category A now becomes= Fruit (apple, orange), Vegetables, People. I want all that in a single column. Thanks very much