Hi everone,

Say I have a table of solutions (S1, S2,....) like this:

S1 S2 S3 S4 S5 . . . . Sn
X1 1 1 1 1 0
X2 0 1 1 0 1
X3 1 1 1 1 0
..
..
..
Xn

As you notice, solutions S2 and S3 are same, so are S1 and S4. In
other words, we have 3 unique solutions (S1, S2, and S5).

I want to auotamically count how many times X1, for example, came 1
among the unique solutions only. The issue here is how to let excel
know that S3 is a copy of S2 and S4 is a copy of S1, and so on.

Is this doable?

Regards,
Mike