Hi all, hoping someone can help me using the attached example. I need a formula that will count how many times "apple" or "orange" appears....but I do not want it to count more than once in the same cell. So for this example, in A1 "apple" appears twice and "orange" appears once - I only want the formula to count it as ONE.
I thought I could use countif......
Thank you for any help!!
I thought I could use countif......
Thank you for any help!!