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

½Ð°ÝÃö©ó¦r¦êªº­Ó¼Æ¥[Á`¡H

½Ð°ÝÃö©ó¦r¦êªº­Ó¼Æ¥[Á`¡H

¦U¦ì¦­¦w¡Aªþ¥ó³o­ÓÀɮ׬O¤@­Ó¥Î¦r¦êºc¦¨ªºªí¡A§Ú§Æ±æ¥i¥H¦b¦C²Ä36~39¡A­pºâ1~4Ãþªº§Þ¯àÁ`­p¡A1~4Ãþ§Þ¯àªº§PÂ_ªk¡A»Ý¬ÝÀx¦s¤º®e¥ªÃä²Ä¤@­Ó¦r¡A­Y"1"ªí¥Ü²Ä¤@Ãþ¡B­Y"2"ªí¥Ü²Ä¤GÃþ¡AÄ´¦p¡GBÄ檺²Ä¤@Ãþ§Þ¯àÁ`­p¦@¦³9­Ó¡FCÄ檺²Ä¤@Ãþ§Þ¯àÁ`­p¦@8­Ó¡A²Ä¤GÃþ«h¦³1­Ó¡A¨Ì¦¹Ãþ±À¡C

¦ý§Ú¥u·Q¨ì¥Îcountif¡A¦ýcountif¦n¹³¥u¯à­pºâ¼Æ¦r¡AµLªk°w¹ï¦r¦ê¡A¥B¦¹ÃD¬O§_¥i¥H°t¦X°}¦C¤½¦¡¨Ï¥Î¡H·PÁ«ü±Ð¡C

³N¬ì§Þ¯à³W½d_ÂÂÃD§ï·sÃD1.rar (12.31 KB)

¦^´_ 1# tku0216

B36=COUNTIF(B$4:B$34,"="&ROW($A1)&"*")
¦V¤U¦V¥k½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ª©¥D¯uªº¤Ó¼F®`¤F!!¥i§_½Ð±Ð­±ªº§PÂ_¦¡ROW($A1)&"*"ªº·N¸q¡H¬°¦ó³o¼Ë´N¥i¥H¦Û°Ê§PÂ_¦¡ÄÝ©ó²Ä´XÃþªº³W½d¡H

TOP

¤]¥i³o¼Ë

B36=COUNTIF(B$4:B$34,LEFT($A36)&"*")
¦V¤U¦V¥k½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁ¨â¦ì¤j¤j¡A§Úª¾¹D¤F¡Aleft»Prowªº¥Îªk³£¬O¬°¤F§ì¨ì1~4³o¥|­Ó¼Æ¦r¡C

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD