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

[µo°Ý] [µo°Ý] °}¦C¤½¦¡§ì¸ê®Æ

[µo°Ý] [µo°Ý] °}¦C¤½¦¡§ì¸ê®Æ

½Ð±Ð°}¦C¤½¦¡¦p¦ó­×§ï !

©óªþ¥óÀɮפ¤ D2Àx¦s®æ ¿ï¨úModel , ¿ï¤j¥þ°tªº«~¶µ§ì¥X¨Óªº°t¥ó¤º®e¨S°ÝÃD¡A ¿ï«D¤j¥þ°tªº«~¶µ®É ·|¦h§ì¦P¦W¤j¥þ°tªº¸ê®Æ¡C

¸ê®Æ§ì¨ú¿ù»~.jpg (148.46 KB)

¸ê®Æ§ì¨ú¿ù»~.jpg

¸ê®Æ¬d¸ß.zip (11.21 KB)

½Ð±Ð F 2: F12 ¸Ìªº°}¦C¤½¦¡­n¦p¦ó­×¥¿  ¤~¤£·|§ì¨ì  ¨ä¥L«~¶µªº°t¥ó¸ê®Æ¡C

TOP

{=INDEX(B:B,SMALL(IF(A$2:A$30=VLOOKUP($D$2,$C$20:$D$23,2,),ROW(B$2:B$30),4^8),ROW(A1)))&""
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# hcm19522


    ·PÁÂ hcm ¤j !
   
    ¦n¥Î!

TOP

¦^´_ 4# ABK

¦pªG¸ê®Æ¦³±Æ§Ç®É

=IF(ROW(A1)>COUNTIF(A:A,OFFSET(D$19,D$2,)),"",INDEX(B:B,MATCH(OFFSET(D$19,D$2,),A:A,)+ROW(A1)-1))
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD