Anonymní profil peter – Programujte.com

chapu, ze to neni dokonale reseni, ze mi tam naskace spoustu kombinaci, co tam nemaji, co delat.
1-1-1-1-2-3 vytvori spoustu kombinaci 1-2-3, takze 1-2-3 se dostane hned top
Ale predpokladam, ze tak nejak ten vysledek bude.
Ale udelat to programem, da presne vysledky.

krok 1, vypsat trojice, =a1, =a2, -a3 | =1a, =a2, =a4...
a b c a b d a b e a b f b c d b c e b c f c d e c d f d e f
1 5 9 1 5 0 1 5 9 1 5 2 5 9 0 5 9 9 5 9 2 9 0 9 9 0 2 0 9 2
3 8 6 3 8 4 3 8 1 3 8 0 8 6 4 8 6 1 8 6 0 6 4 1 6 4 0 4 1 0
4 8 3 4 8 3 4 8 8 4 8 7 8 3 3 8 3 8 8 3 7 3 3 8 3 3 7 3 8 7
3 2 9 3 2 0 3 2 1 3 2 2 2 9 0 2 9 1 2 9 2 9 0 1 9 0 2 0 1 2
7 2 7 7 2 7 7 2 3 7 2 8 2 7 7 2 7 3 2 7 8 7 7 3 7 7 8 7 3 8
6 7 3 6 7 4 6 7 8 6 7 5 7 3 4 7 3 8 7 3 5 3 4 8 3 4 5 4 8 5
4 0 2 4 0 3 4 0 3 4 0 1 0 2 3 0 2 3 0 2 1 2 3 3 2 3 1 3 3 1
3 1 2 3 1 1 3 1 9 3 1 8 1 2 1 1 2 9 1 2 8 2 1 9 2 1 8 1 9 8
5 7 8 5 7 3 5 7 9 5 7 9 7 8 3 7 8 9 7 8 9 8 3 9 8 3 9 3 9 9
2 3 6 2 3 8 2 3 3 2 3 0 3 6 8 3 6 3 3 6 0 6 8 3 6 8 0 8 3 0
2 7 3 2 7 8 2 7 4 2 7 7 7 3 8 7 3 4 7 3 7 3 8 4 3 8 7 8 4 7
0 1 2 0 1 2 0 1 5 0 1 1 1 2 2 1 2 5 1 2 1 2 2 5 2 2 1 2 5 1
0 5 5 0 5 5 0 5 4 0 5 3 5 5 5 5 5 4 5 5 3 5 5 4 5 5 3 5 4 3
3 3 9 3 3 0 3 3 4 3 3 7 3 9 0 3 9 4 3 9 7 9 0 4 9 0 7 0 4 7
8 4 8 8 4 4 8 4 0 8 4 4 4 8 4 4 8 0 4 8 4 8 4 0 8 4 4 4 0 4
8 8 4 8 8 7 8 8 1 8 8 4 8 4 7 8 4 1 8 4 4 4 7 1 4 7 4 7 1 4
3 4 3 3 4 6 3 4 2 3 4 3 4 3 6 4 3 2 4 3 3 3 6 2 3 6 3 6 2 3
5 1 6 5 1 2 5 1 8 5 1 9 1 6 2 1 6 8 1 6 9 6 2 8 6 2 9 2 8 9
4 6 0 4 6 6 4 6 8 4 6 5 6 0 6 6 0 8 6 0 5 0 6 8 0 6 5 6 8 5

krok2 seradit =MIN(A2:C2), ?, =MAX(A2:C2),
? = =IF(OR(AND(A2<=B2; B2<=C2);AND(C2<=B2; B2<=A2));B2;IF(OR(AND(B2<=A2; A2<=C2);AND(C2<=A2; A2<=B2));A2;C2))

a b c a b d a b e a b f b c d b c e b c f c d e c d f d e f
1 5 9 0 1 5 1 5 9 1 2 5 0 5 9 5 9 9 2 5 9 0 9 9 0 2 9 0 2 9
3 6 8 3 4 8 1 3 8 0 3 8 4 6 8 1 6 8 0 6 8 1 4 6 0 4 6 0 1 4
3 4 8 3 4 8 4 8 8 4 7 8 3 3 8 3 8 8 3 7 8 3 3 8 3 3 7 3 7 8
2 3 9 0 2 3 1 2 3 2 2 3 0 2 9 1 2 9 2 2 9 0 1 9 0 2 9 0 1 2
2 7 7 2 7 7 2 3 7 2 7 8 2 7 7 2 3 7 2 7 8 3 7 7 7 7 8 3 7 8
3 6 7 4 6 7 6 7 8 5 6 7 3 4 7 3 7 8 3 5 7 3 4 8 3 4 5 4 5 8
0 2 4 0 3 4 0 3 4 0 1 4 0 2 3 0 2 3 0 1 2 2 3 3 1 2 3 1 3 3
1 2 3 1 1 3 1 3 9 1 3 8 1 1 2 1 2 9 1 2 8 1 2 9 1 2 8 1 8 9
5 7 8 3 5 7 5 7 9 5 7 9 3 7 8 7 8 9 7 8 9 3 8 9 3 8 9 3 9 9
2 3 6 2 3 8 2 3 3 0 2 3 3 6 8 3 3 6 0 3 6 3 6 8 0 6 8 0 3 8
2 3 7 2 7 8 2 4 7 2 7 7 3 7 8 3 4 7 3 7 7 3 4 8 3 7 8 4 7 8
0 1 2 0 1 2 0 1 5 0 1 1 1 2 2 1 2 5 1 1 2 2 2 5 1 2 2 1 2 5
0 5 5 0 5 5 0 4 5 0 3 5 5 5 5 4 5 5 3 5 5 4 5 5 3 5 5 3 4 5
3 3 9 0 3 3 3 3 4 3 3 7 0 3 9 3 4 9 3 7 9 0 4 9 0 7 9 0 4 7
4 8 8 4 4 8 0 4 8 4 4 8 4 4 8 0 4 8 4 4 8 0 4 8 4 4 8 0 4 4
4 8 8 7 8 8 1 8 8 4 8 8 4 7 8 1 4 8 4 4 8 1 4 7 4 4 7 1 4 7
3 3 4 3 4 6 2 3 4 3 3 4 3 4 6 2 3 4 3 3 4 2 3 6 3 3 6 2 3 6
1 5 6 1 2 5 1 5 8 1 5 9 1 2 6 1 6 8 1 6 9 2 6 8 2 6 9 2 8 9
0 4 6 4 6 6 4 6 8 4 5 6 0 6 6 0 6 8 0 5 6 0 6 8 0 5 6 5 6 8
krok 3 spojit na cisla a*100 + b+10 + c*1
krok 4 soucty pres kontingencni tabulky, resp, dam to do jednoho sloupce, aby stacila 1 tabulka,
Nad sloupec davam aaa, oznacim, vlozit - konting. tabulka, ok, pretahnu aaa do 'hodnoty', pokud je tam soucet, tak to zmenim na pocet. A pretahnu aaa tez do sloupce.
Vyslednou dvojradkovou tabulku oznacim, zkopiruji na jiny list a dam seradit. ctrl+c, upravy > vlozit jinak, vlozit jinak, transpondovat. Oznaci, seradim podle 'Pocet z aaa' DESC. Sem davam jen prvnich top-n

	Počet z aaa
378	7
448	6
348	5
12	4
23	4
29	4
68	4
125	4
277	4
334	4
488	4
48	3
123	3

Cili, nejcastejsi trojice cisel tam jsou
378 , 448, 348, 012, 023
 

Samozrejme je to napikacu postup, ale jde to i v excelu a netrva to dlouho. Kdyz vynecham zadrhely s tim, ze mi excel cosi zmenil na bunkach a pak mi min max zahadne zobrazovalo spatna cisla :) a musel jsem to pretahnout pres far, ktery mi odboural excel formatovani a tak, tak asi 5 min. Havam, ze pro 4000 radku by to bylo asi narocnejsi, tak 30-60 min.
Zajimalo by mne, co vyplivne program. Nechce se mi ho ted sepisovat.