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

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

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

1533267923176.jpg
2018-8-3 11:52

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

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

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

TOP

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

111.rar (13.31 KB)

TOP

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

§A°Ñ¦Ò¬Ý¬Ý

    111.zip (14.05 KB)

TOP

D2¥k©Ô ¤U©Ô{=INDEX(C:C,SMALL(IF($B$16:$B$28=$C$2,ROW(B$16:B$28),4^8),ROW(A1)))&""
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# a5007185


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

TOP

1533342125180.jpg
2018-8-4 08:22
¦^´_ 5# hcm19522


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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD