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

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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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))),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD