- ©«¤l
- 14
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 53
- ÂI¦W
- 0
- §@·~¨t²Î
- XP, Vista & Window7
- ³nÅ骩¥»
- Office 2003 & 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-16
- ³Ì«áµn¿ý
- 2023-5-30
|
¦^´_ 7# Qin
Åçºâ!A1=1830¡ö½Ð¦Û¦æ¶ñ¤J¡A¬° ¨Ó·½!$A:$A ¥¼§ó°Ê«e쥻 ID Á`È¡C
Åçºâ!A2=IF(SUM(¨Ó·½!$A:$A,¥Ø¼Ð!$A:$A)=Åçºâ!$A$1,"OK","Åçºâ¿ù»~")
¨Ò¤l 1830 ¬O¦@ 60 ¦Cªº¸ê®Æ¡A1+2+...+60 ªºÈ¡CY¬O 5000 ¦C¡AÀ³¸Ó¬O 12502500¡C
¥t¥~¡A¾Þ§@Y¬O¦P¤@ Sheet¡A°Å¤U¡÷´¡¤J½Æ»sªºÀx¦s®æ¡A¸ê®Æ·|¦Û°Ê¤W²¾¡C¦ýY¬O¡A¦b¤£¦Pªº Sheet ¤W¾Þ§@¡A¨Ó·½ªº¤u§@ªí·|¯d¤UªÅ¥ÕªºÀx¦s®æ¡C |
|