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

[µo°Ý] Excel¤U©Ô¿ï³æ¶Ç¦^­Èªº°ÝÃD

[µo°Ý] Excel¤U©Ô¿ï³æ¶Ç¦^­Èªº°ÝÃD

Dear  ¦U¦ì¥ý¶i­Ì¦n¡A

¤â¤W¦³¤@­Ó°ÝÃD·Q½Ð±Ð¡A

¦bExcel°µ¤@­Ó©Ê§Oªº¤U©Ô¦¡¿ï³æ¡A¦pªG¨Ï¥ÎªÌÂI¿ï¨k¥Í¡A¸ÓÄ檺­È´N·|¶Ç¦^0¡A¤k¥Íªº´N¬O1

²³æ¨Ó»¡¡A¤U©Ô¦¡¿ï³æ¤º®e¬O¡u¨k¡v¸ò¡u¤k¡v¡AÂI¿ï«á¶Ç¦^Äæ­È¬O¡u0¡v¸ò¡u1¡v

§Ú¦bGoogle¤W­±·j´M¤F«Ü¤[¡A³£¨S¦³Âç²M¤@­Ó¤è¦V¨Ó¡A¤£ª¾¥i¥H½Ð¤j¤j«üÂI°g¬z©O¡H

·PÁÂ

¥»©«³Ì«á¥Ñ StanleyVic ©ó 2011-7-11 14:52 ½s¿è



§Ú¬Ý¼Ó¥D©Ò´£°Ýªº¬O. :  
"ªí³æ" ¤¤ªº "¤U©Ô¦¡¤è¶ô"
½Ð°Ñ¦Ò¤W¹Ï,§Æ±æ¹ï§A¦³À°§U.


¦ý½Ð°Ý..¦³ ¶Ç¦^ 0©M1 ³o¼Ë¶Ü??
NeverTry , NeverNo !

TOP

¥»©«³Ì«á¥Ñ chiahuo ©ó 2011-7-12 09:16 ½s¿è

°µªk¦p¤U
²M³æ¤Î¶Ç¦^­Èªº°µªk¦p¤U°Êµe¡G
=COUNTIF(A1,"¤k")     =1
¦pªGA1¬O¤k           =1
¦pªGA2¬O¨k           =0
³Ñ¤U©Ô´_¨î

1.gif
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¥Î¤F¤TºØ¤è¦¡ °Ñ¦Ò¬Ý¬Ý¬O§_¦X¥Î? ©Ê§O.rar (5.94 KB)

TOP

¤£¯à¥Îb2=if(a1="¨k",1,0)¤U©Ô½Æ»s¨Ó§@¶Ü
jeason

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD