How doable Using Excel?

[Michael]

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

 

[Nikos Yannacopoulos]

Michael,

As long as n (in Xn) <= 255, you acn transpose the table, so solutions
become rows, and then use Data > Filter > Advanced Filter, checking Unique
Records Only, to get unique solutions. This done, all you need is a
summation at the bottom of the columns.

HTH,
Nikos