- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¦^´_ 3# hcm19522
ªþ¥ó :
¨ç¼Æ_°ÊºA°Ñ·Ó¤½¦¡ªº½s¼g-0120.rar (12 KB)
¤£¦n·N«ä¡AÁÙ¦³¤@ÓÃþ¦üªº»Ý¨D¡A¥½¾Ç«_¬N¦A½Ð±Ð :
M10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:M$1)-B10,10)),B10,""))}
M10ªº¤½¦¡»Ý¨D¡G
·í$L$1=""®É¡A«hM10=""¡F·í($B10:$F10)/10ªº¾l¼Æ=($B11:$F11)/10ªº¾l¼Æ¡F«hM10=B10¡A§_«hM10=""¡C
M10¥k©Ô¨ìQ10¡F
Q10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:Q$1)-F10,10)),F10,""))}
¥H¤U¡K¡K.¦P²zÃþ±À¡C
S10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:S$1)-B10,10)),B10,""))}
S10¥k©Ô¨ìW10
W10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:W$1)-F10,10)),F10,""))}
Y10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:Y$1)-B10,10)),B10,""))}
Y10¥k©Ô¨ìAC10
AC10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:AC$1)-F10,10)),F10,""))}
AE10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:AE$1)-B10,10)),B10,""))}
AE10¥k©Ô¨ìAI10
AI10{=IF($B11="","",IF(OR(MOD($B11:$F11,10)=MOD(LOOKUP(99,$M$1:AI$1)-F10,10)),F10,""))}
½Ð°Ý¡G¥ÑM10¥k©Ô¦A¤U©Ô¨ìAI21¤@¦¡¨ì¦ìªº¨ç¼Æ¤½¦¡n¦p¦ó½s¼g¡H
|
|