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

[µo°Ý] ³sÄòªÅ®æªº½s¸¹¡I

[µo°Ý] ³sÄòªÅ®æªº½s¸¹¡I

½Ð°Ý¦U¦ì¥ý¶iªþÀɪº°ÝÃD¦p¦ó¸Ñ¡AÁÂÁ¡I

°ÝÃD.rar (6.55 KB)

¦^´_ 1# shan0948
Àx¦s®æA3¿é¤J
=IF(B3="","",COUNTA($B$3:B3))
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# shan0948


=IF(INDIRECT("RC2",)="","",MAX(INDIRECT("R[-1]C:R2C",))+1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# p212
·PÁÂP212¤j¤jªº«ü¾É¨ç¼Æªº³]©w,¸g´ú¸Õ«á§¹¥þ²Å¦X»Ý¨D,¦A¦¸·PÁÂ!!

TOP

¦^´_ 3# ML089

·PÁÂML089¤j¤jªº«ü¾É¨ç¼Æªº³]©w,¸g´ú¸Õ«á¥ç²Å¦X»Ý¨D,¦A¦¸·PÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD