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

[µo°Ý] ­û¤u­È¯Zªí¤@°Ý¡H

[µo°Ý] ­û¤u­È¯Zªí¤@°Ý¡H

¤u§@ªí¬O12¤ë¥÷­û¤u½ü­Èªí¡A¦ý¦p¦ó±N¥Ò¤Î¤A¦b12¤ë©Ò­È¯Zªº¤é´Á
(¤À«D°²¤é»P°²¤é¡^µ¹Åã¥Ü¥X¨Ó¡H
¸Ôªþ¥ó

¢²¢ù

ªþ¥ó.rar (8.42 KB)

¦^´_ 1# q1a2z5


¥Ò«D°²¤éC3=IFERROR(INDEX(¤u§@ªí!$A:$A,SMALL(IF(((¤u§@ªí!$C$2:$C$34=$A$3)+(¤u§@ªí!$D$2:$D$34=$A$3))*((¤u§@ªí!$B$2:$B$34<>"¤»")*(¤u§@ªí!$B$2:$B$34<>"¤é")),ROW($C$2:$C$34),""),COLUMN(A1))),"")

¥Ò°²¤éC5=IFERROR(INDEX(¤u§@ªí!$A:$A,SMALL(IF(((¤u§@ªí!$C$2:$C$34=$A$3)+(¤u§@ªí!$D$2:$D$34=$A$3))*((¤u§@ªí!$B$2:$B$34="¤»")+(¤u§@ªí!$B$2:$B$34="¤é")),ROW($C$2:$C$34),""),COLUMN(A1))),"")

¥H¤W³£¬O°}¦C¤½¦¡¡A¬õ¦âªº½Ð¦Û¦æ­×§ï¬°¤A(a6)

TOP

¨º¦pªG¤À«D°²¤é¤Î°ê©w°²¤é¡B¬P´Á¤»¤Î¬P´Á¤é¡A¥i¦³¤èªk¤À§OÅã¥Ü¥X¨Ó¡H
¦pªþ¥ó
ÁÂÁ¡I

ªþ¥ó.rar (6.65 KB)

TOP

¦^´_ 3# q1a2z5
¦pªþ¥ó

ªþ¥ó1.zip (8.45 KB)

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD