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

¬d¸ß¤½¦¡°ÝÃD½Ð±Ð

¬d¸ß¤½¦¡°ÝÃD½Ð±Ð


·Q½Ð°Ý¦U¦ì«e½ú~¦p¦ó¤~¯à¦b¬d¸ß¦³­«½Æ®Æ¸¹¦ý¦³¤£¦Pªº¸ê°T®É~¤£­n¥u­«½ÆÅã¥Ü²Ä¤@µ§¸ê®Æ¦Ó¬O§ì¥X©Ò¦³¸ê°T~·PÁÂ

1533267923176.jpg (341.15 KB)

1533267923176.jpg

Q1:±ø¥ó²Å¦X ,©Ò»Ý¦C¸¹   ,±ø¥ó¤£²Å¦X-->4^8-->65536¦C¸¹ ,«Ü¤j¸¹ ,¤£¥i¯à¦³¸ê®Æ ;·í±q³Ì¤p¦C¸¹§ì°_ ¨ì±ø¥ó¤£²Å¦X®É¬°65536-->¬°ªÅ °t¦X«á­± &""  «h¦¨ªÅ¥Õ   ,­YµL""«h¬° 0
Q2:ROW(A1)-->1   ,A1. B1 .C1...§¡¬°1    ;ROW(A2)-->2   A2 B2 C2...§¡¬°2 ,¬Ý¼Æ¦r ,¤£ºÞ¦r¥À
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 5# hcm19522

·PÁ«e½ú~¥t¥~·Q½Ð±Ð2­Ó°ÝÃD~§Æ±æh¤jµ¹¤©«ü±Ð

TOP

¦^´_ 4# a5007185


    ·PÁ«e½úªº«ü¾É~¥i¥H¨Ï¥Î~ÁÂÁÂ{:3_59:}

TOP

D2¥k©Ô ¤U©Ô{=INDEX(C:C,SMALL(IF($B$16:$B$28=$C$2,ROW(B$16:B$28),4^8),ROW(A1)))&""
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# ¤p¸ô¦èªk

§A°Ñ¦Ò¬Ý¬Ý

    111.zip (14.05 KB)

TOP

¦^´_ 2# a5007185
¥H¤W¶ÇÀÉ®×~ÁÂÁÂ

111.rar (13.31 KB)

TOP

¦^´_ 1# ¤p¸ô¦èªk

¦³¨S¦³ªþÀÉ¡H

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD