Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How doable Using Excel?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How doable Using Excel?
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 "Michael" wrote in message m... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How doable Using Excel?
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to add same value to every cell...Is that doable? | Excel Discussion (Misc queries) | |||
Is this doable using excel? | Excel Programming | |||
Is this doable using Excel? | Excel Programming |