condition expression

[Anonymous]

Hi,

Could you help me to create condition for calculation?

Question1	Question2
a	Female
b
c
d
e
a	Male
b
c
d
e
a	Male
b
c
d
e
a	Female
b
c
d
e
a
b
c
d
e

Count the number of values for column B (Question2) if the number of  corresponding distinct values for column A (Question1) equals or more than 2.

Thanks and I hope you understand what I want,

[sushil353]

Sorry, Your requirement is not clear.

What should be the final result of above table?

so that we can understand your requirement.

HTH

Sushil

[Anonymous]

I need to create condition. It should work, when in Question1 has answers in Question2 more than for 1.

If you see in my table. Question2 has answers only for a in Questions1.

Condition should work, when Qustion2 has answers more than for 1 any tag(a and b, or b and c ...)

Thanks,