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

[µo°Ý] °Ñ·Ó¤£¦PÄæ¦ì¸ê®Æ®w

[µo°Ý] °Ñ·Ó¤£¦PÄæ¦ì¸ê®Æ®w

½Ð°Ý°Ñ·Ó"¸ê®Æ®w"¤º¦ì©ó¤£¦PÄæ¦ì¡A
±a¥X·Q­nªº¸ê®Æ¡A¤½¦¡¸Ó¦p¦ó¼g¡A
¸Ô²Ó»¡©ú¦bªþ¥ó¤º¡A
½Ð«e½ú«ü¾É¤@¤U¡A
·P¿E¤£ºÉ!

°Ñ·Ó¤£¦PÄæ¦ì¸ê®Æ®w.rar (9.91 KB)

aa.zip (12.29 KB)

TOP

¦^´_ 2# ANGELA

ÁÂÁÂANGELA¤j¤jªº¦^µª
·Q½Ð±Ð¤@¤U
1.µ²ªGsheet¤ºc2Àx¦s®æ={=INDEX(¸ê®Æ®w!A:A,MIN(IF(¸ê®Æ®w!$G$2:$K$8=$A2&$B2,ROW($A$2:$A$8),11)))}
   ¤½¦¡¤º11¥Nªí¤°»ò§t·N¡A¦³ÂI¤£À´¡A¥i¥H¸ÑÄÀ¤@¤U¶Ü?
2.¦]¬°§Úªº¸ê®Æ®w¤Îµ²ªGsheet¦³¤W¤dµ§¸ê®Æ¡A¥i¯à¤£¤Ó¾A¥Î¨ç¼Æ¯x°}¤è¦¡¡A·|³y¦¨³B²z¸ê®Æ³t«×ÅܺC
   ¥i¯à§ï¥ÑVBA¤è¦¡³B²z¸û§´·í¡A¥t§ïpoµ{¦¡°Ï´M¨D¸Ñ¨M¤ñ¸û¾A·í¡A«D±`·PÁ±zªº¦^µª!

TOP

¦^´_ 3# pesi2884


    11¤£¥Nªí¥ô¦ó§t¸q,¤@¯ë¬O¥Î65536,¥u­n¤ñ§A¨Ï¥Îªº½d³ò¤j§Y¥i.

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD