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

[µo°Ý] ¦Û°Ê¥X²{½Òªí¸Ìªº¸ê®Æ¡H

¦^´_ 1# onegirl0204

¥u¥X²{¦Ñ®v½Ð°²ªº½Òªí
±Æ¥N½Ò.zip (5.28 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# onegirl0204


    ¸ê®Æ®w¤£¬O³o¼Ëª±ªº
±Æ¥N½Ò-1.rar (5.92 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# onegirl0204

¤Ö¤F¤@­Ó±ø¥ó
=IF((a<>"")*(A$3=w),INDEX(¦Ñ®v±Â½Òªí!$D$1:$D$40,SUMPRODUCT((¦Ñ®v±Â½Òªí!$A$2:$A$40=±Æ¥N½Òªí!$E$1)*(¦Ñ®v±Â½Òªí!$C$2:$C$40=a)*(¦Ñ®v±Â½Òªí!$B$2:$B$40=w)*(ROW($2:$40))),),"")
±Æ¥N½Ò.rar (4.5 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD