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

±N¹F¨ì¿n¤Àªº½s¸¹ ±Æ¦C¿z¿ï¥X¨Ó

±N¹F¨ì¿n¤Àªº½s¸¹ ±Æ¦C¿z¿ï¥X¨Ó

¥»©«³Ì«á¥Ñ eric7765 ©ó 2021-3-12 13:21 ½s¿è

¹Ï¤ù¬°¤u§@ªí1 A1 ¬O¿n¤À¼Ð·Ç ¡ABÄæ¬O½s¸¹ ¡A¦p¦ó¦b¤u§@ªí2 ¬Û¹ïÀ³ªº¦ì¤l §â¹F¨ì¿n¤À¼Ð·Çªº ªº½s¸¹Åã¥Ü¥X¨Ó´N¦n ³Â·Ð¦U¦ì¤F
¤u§@ªí2 ¤£¥ÎÅã¥Ü¿n¤À ª½±µ±N·í¤é¹F¨ì¿n¤Àªº½s¸¹ ±Æ¦C¥X¨Ó§Y¥i
°ÝÃD.png
2021-3-12 13:18

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

TOP

¦^´_ 2# hcm19522


    h ¤j¤j±z¦n¡A±zªº¤½¦¡¤¤½s¸¹¬O¨ú±o¼Æ­ÈªºÅã¥Ü¡A¦ý¦pªGªí¤ºªº½s¸¹¬O¤å¦r¡A«h¤½¦¡ªºÀx¦s®æ§¡Åã¥ÜªÅ¥Õ¡A½Ð°Ý½s¸¹¬O¤å¦r¤½¦¡­n¥Î´«¨º­Ó¨ç¼Æ¡AÁÂÁ·P®¦¡I

TOP

¦^´_ 3# shan0948
·Q¤F¸Ñ+1 §Ú¥Ø«eªº¤èªk ¬O¦b¶}¤@­Ó ¤u§@ªí µM«á¥Î vlookup ¨ç¼Æ¥h¤ñ¹ï¥X¨Ó
¤]·Q¤F¸Ñ §ó¦nªº´À¥N¤è®×

TOP

¦^´_ 3# shan0948

¨Ì 2¼Óªí®æ   J2:O16{=INDEX($B:$B,SMALL(IF(C$2:C$16>=$A$2,ROW($2:$16),4^8),ROW(A1)))&""
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 5# hcm19522


    h ¤j¤j¤È¦w¡A¤½¦¡¥i¥HÅã¥Ü«D¼Æ­ÈªºÀx¦s®æ¡A¤p§Ì»{¬°¬Û¹ï¤§¤U§ó²¤Æ¤F¡A¥t¥~½Ð±Ð³Ì«á¤@­Ó©µ¦ùªº°ÝÃD¡A¦p¦óÅã¥Ü¦³¤G¤Ñ©Î¥H¤W¦P¤@­Ó¿n¤À(¨Ò¦p700)ªº½s¸¹¦³¨º¨Ç¡HÁÂÁ¡I

TOP

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

TOP

¦^´_ 7# hcm19522


     h ¤j¤j±ß¦w¡A±zªGµM¼F®`¡A§¹¥þ¹F¨ì¥Ø¼Ð¡A¦Ó¥B¥i¥H§ïÅܤ覡°µ¨ä¥L¥Î³~¡A¤]¾Ç¨ì¤F«Ü¦h¡AÁÂÁ«ü±Ð¡I

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD