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

[µo°Ý] «ü©w·j´M½d³òªº¨ç¼Æ¤½¦¡

[µo°Ý] «ü©w·j´M½d³òªº¨ç¼Æ¤½¦¡

¥»©«³Ì«á¥Ñ johnny1680 ©ó 2021-12-11 01:18 ½s¿è

«ü©w·j´M½d³òªº¨ç¼Æ¤½¦¡.rar (1.81 KB)
¥ý¥H·Æ¹«°é¿ïA1:A28¡F
«á¦b®æ¦¡¤Æ±ø¥ó(¤@)ªºÀx¦s®æ­È¶ñ¤J"µ¥©ó"¡F$B$1
¹Ï¼Ë=¶À¦â
¨ú±o¦pA1:A28ªº¹Ï¥Ü¡C

¦pªG·Q§ï¥H®æ¦¡¤Æ±ø¥óªº¤½¦¡ªí¹F¡J
±NA1¨ìAÄæ­Ë¼Æ²Ä¤G­Ó(COUNTA(A:A)-1)«DªÅ¥ÕÀx¦s®æ¥B=$B$1ªº¦UÀx¦s®æ¼Ð¥Ü¶À©³¦â¡A
½Ð°Ý¡J®æ¦¡¤Æ±ø¥ó(¤@)ªº¤½¦¡­n¦p¦ó½s¼g¡H
ÁÂÁ¡I

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522
·PÁ±zªº«ü¾É¡C
¥u¬O§Æ±æ¯à¤£¯à¤£­n¦A¼W¥[»²§UÄæÀx¦s®æ^^
ÁÂÁÂ!

TOP

¦^´_ 2# hcm19522
°é¿ïAÄæ
­l¤Æ2¼Óªº¤½¦¡
®æ¦¡¤Æ±ø¥ó(¤@)¤½¦¡
A1
=OR($A1=B$1)*(ROW()<=MATCH(9E+307,$A:$A)-1)


¦p¦³¨ä¥¦§ó²¤Æªº¤½¦¡¡A©|½Ð¦U¦ì¤j¤j¤£§[½ç±Ð!ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD