Hello,
My data is as follows:
Column A
1. Apple
2. Banana
3. Apple
4. Orange
5. Apple
6. Banana
7. Chickoo.
I want a formula which gives result as 2 as only 2 items apple & banana is duplicated irrespective of their number of occurances.
Thank you.
Vivek.
Bookmarks