Remove duplicate

I have 3 select multiple question. I need to find the unique number of the selected option in all three of them which does not include “None”.

Hi @arunrock,

The best solution that come to my mind is to add a formula to count the total number option selected in each question and keep them in measure. I made and example file for you.

aw7ZMcZ3nW8KggjGXZABgB.xlsx (6.7 KB)

1 Like