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

[µo°Ý] ¤À§O¤p­p¦U¶µ¸ê®Æ?

[µo°Ý] ¤À§O¤p­p¦U¶µ¸ê®Æ?

½Ð°Ý¡G
¢°¡B¦p¦ó¤À§O²Î­p¦U¦a°Ï¸ê®Æ1¤Î¸ê®Æ2ªº¦¸¼Æ©O?
¢±¡B¦bK3¦ÜK10¬°¸ê®Æ°Ï¡A¦bÀx¦s®æ¤ºÅã¥Üªº¸ê®Æ¦³¡G¤é´Á¡B®É¶¡µ¥¡A¦ý§Ú·Q­n¨ú¥Xªº¤é´Á«¬ºA¬°¦pLÄæ©ÒÅã¥Ü?
¡@¡@¤½¦¡­n¦p¦ó³]©w©O¡H
ÁÂÁ¡I

¤À§O¤p­p¦U¶µ¸ê®Æ.zip (8.51 KB)

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

ÁÂÁ¤j¤jªº¸Ñµª¡A¨º¯à¤£¯à¶i¤@¨BªºÅã¥Ü¥X¥x¥_¦a°Ï¸ê®Æ¢°¤p­pªº©Ò¦b¦C©ú²Ó¡H
¦pªþ¥ó¡]¥kÃäªí®æ©Ò¥Ü¡^
¢²¢ù

Åã¥Ü¤p­p¦U¶µ¸ê®Æ©ú²Ó.ZIP (9.64 KB)

TOP

J2:K25{=IFERROR(INDEX($C:$C,SMALL(IF((LOOKUP("¼_",$G$2:$G2)=$A$2:$A$9)*($B$2:$B$9=$H2),ROW($2:$9)),COLUMN(A1))),"")

N2:O25{=IFERROR(INDEX($E:$E,SMALL(IF((LOOKUP("¼_",$G$2:$G2)=$A$2:$A$9)*($D$2:$D$9=$L2),ROW($2:$9)),COLUMN(A1))),"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD