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

[µo°Ý] ¤£­«½Æªº¼Æ¾Ú±Æ¦C»P­«½Æªº¼Æ¾Ú¦C­p¹Bºâ¤è¦¡­n¦p¦ó½s¼g?

[µo°Ý] ¤£­«½Æªº¼Æ¾Ú±Æ¦C»P­«½Æªº¼Æ¾Ú¦C­p¹Bºâ¤è¦¡­n¦p¦ó½s¼g?

·Q½Ð°Ý¯¸¤Wªº¦U¦ì«e½ú­Ì
§Ú¦³¤@¤ÀÃþ¹Bºâ­n°µ

²Ä¤@¦C¦³­«½Æ¤H¦W
·Q¦b²Ä¤G¦C°µ¥X¤H¦W¥N¸¹

¤£­«½Æªº¤H¦W¥N¸¹ªº±Æ¦C¬°A~Z¡A¦bÅܦ¨AA~AZ¡A¥H¦¹Ãþ±À
­Y­«½Æªº¤H¦W¡A­^¤å¥N¸¹«á¤è·|¦A¼W¥[¼Æ¦rA1~A99¡A¥H¦¹Ãþ±À

¯¸¤W¬d¸ß¨ìªº¤å³¹¤j³¡¤À¬O­«½Æªº¼Æ¾ÚÁ`¦X¡A©ÎªÌ¤£­«½Æªº¼Æ¾Ú¥t¥~¦C¥X
½Ð°Ý¦¹¤½¦¡¥i§_¤£¨Ï¥Î°}¦C¤½¦¡½s¼g?

http://blog.xuite.net/hcm19522/twblog/357967980

TOP

AÄæ¶ñ­«½Æ¤H¦W¡A¥ÑA2¶}©l¶ñ
B2 =IF(MATCH(A2,A:A,)<>ROW(),"",MAX(B$1:B1)+1)
C2 =ADDRESS(COUNTIF(A$1:A2,A2),VLOOKUP(A2,A:B,2,),4)
B2 C2 ¤½¦¡©¹¤U½Æ»s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·Q¤F¤@¬q®É¶¡
¤£¹L³s³Ì°ò¥»ªº¼Æ­^Âà´«³£¤£ª¾¹D«ç»ò¤U¤â..
¦b½Ð¯¸¤Wªº¤j¤j­ÌÀ°À°¦£
·PÁÂ¥ý~

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD