ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[¤À¨É] ·q¯¬:¦U¦ì¤¤¼ú

[¤À¨É] ·q¯¬:¦U¦ì¤¤¼ú

·q¯¬:
ª÷Âû³ø³ß!
°]·½¼s¶i!

Lottos.png
2017-1-28 13:12

Lottos_¤j¼Ö³z©M¦Ê¸U¬õ¥]¹ï¼ú.rar (7.95 KB)

¦^´_ 1# Airman


    Lottos_¤j¼Ö³z©M¦Ê¸U¬õ¥]¹ï¼ú_KK.rar (9.94 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2017-1-29 07:55 ½s¿è

¦^´_ 2# ML089
ª©¥D¤j¤H:¦­¦w!
ÁÂÁ¤À¨É~
¤×¨ä¬OR2ªº¤½¦¡~ÁÂÁ¤£§[«ü¾É

TOP

¢à¢±¡D°}¦C¤½¦¡¡G
=SUBSTITUTE(MID("0¤C´¶¤»¤­¥|¤T¤GÀY",MAX(1,SUM(COUNTIF(K2:P2,OFFSET(B$1,J$1,,,7))*{2,2,2,2,2,2,1})-3),1)&"¼ú","0¼ú",)

¢á¢±¡D°}¦C¤½¦¡¡G
=IF(COUNT(RANK($K2:$P2,OFFSET($B$1,$J$1,,,6)))=S$1,"V","")

¢ç¢±¡G
°}¦C¡G=IF(OR(K2:P2=INDEX(H:H,J$1+1)),"V","")
¤@¯ë¡G=IF(MODE(K2:P2,INDEX(H:H,J$1+1),0,0),"V","")
¡@
¡@

TOP

¦^´_ 4# ­ã´£³¡ªL
­ã´£ª©¥D¤j¤H:±z¦n!
ÁÂÁ¤À¨É~¤½¦¡·U¨Ó·Uµu¡C
¸U¤À·P¿E±zªº¤£§[«ü¾É

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD