¬Û¦P¸ê®Æ°µ±Æ§Ç°ÝÃD ¬Û¦P¸ê®Æ±Æ§Ç

lsoavme2

¤j®a¦n¡A³o¬O§Ú¦b³o¸Ì²Ä¤@¦¸ªºµo¤å¡C
·Q½Ð°Ý¦U¦ì°ª¤â¡A¦pªG§Ú¤µ¤Ñ¦³¤@¦C¤£°µ¤j¤p±Æ§Çªº¸ê®Æ¡A¦ý¬O¸Ì­±¦³­«½Æªº¡A¦³¿ìªk¥i¥H°µ1¡B2¡B3ªº±Æ§Ç¶Ü??
¦p¤U¹Ï§ÚÀ³¸Ó­n­n¦bAF2®I¤J¤°»ò¤½¦¡¤~¯à°µ¶µ¦¸1¡B2¡B3ªº±Æ§Ç¡C
§Ú¦³¸Õ¹L³o­Ó¤½¦¡=IF(AA4=AA3,AF2+1,1)¡AµM«áAF³]©w¬°1¡A¦ýµo²{¦pªG­q³æ¸¹½X¨S¦³°µ±Æ§Çªº¸Ü¡A§Ú¥X¨Óªº­È´N¤£¥¿½T¤F¡C
¸ê®ÆAAÄæµLªk°µ±Æ§Ç¡A¦]¬°¥L¬O¨Ì·Ó¤U³æ¶¶§Ç·s¼W¡C

Àµ½Ð¦U¦ì°ª¤â±Ï±Ï§Ú~:) :)

¤U¸ü (18.47 KB)
¹Ï¥Ü¤@

2016-3-10 10:51

hcm19522

AF2¿é¤J 1
AF3=IF(AA3="","",IF(AA2=AA3,AF2,AF2+1))

lsoavme2

¦^´_ 2# hcm19522

¥i¬O§ÚªºAAÄ椣·|°µ¬Û¦P¸¹½X±Æ§Ç¡AAAÄ檺¼Æ­È·|­«½ÆÁÙ·|¸õÄæ¦ì¡C³o¼ËÀ³¸Ó´N¤£¦æ°µ123ªº¶µ¦¸±Æ§Ç¤F§a?

­ã´£³¡ªL

=COUNTIF(AA$1:AA2,AA2)

lsoavme2

¦^´_ 4# ­ã´£³¡ªL

ÁÂÁ±z!!§Ú¦¨¥\ªº±Æ§Ç¤F¡A¥i¬O¥¦ªº­ì²z¬O¤°»ò?§Ú¤µ¤Ñ¤]¦³¸Õ¡A¦ý¬O¤@ª½³£¤£¦¨¥\¡C¥i¥H½Ð±z§i¶D§Úµª®×¶Ü??ÁÂÁÂ!!

­ã´£³¡ªL

¦^´_ 5# lsoavme2


¥h¬ÝCOUNTIFªº»¡©ú!!!

AA$1:AA2 ¤U©Ô·|³vº¥¼W¥[°Ñ·Ó½d³ò(AA$1:AA???), ­pºâ¦Ü·í®æ¬°¤î, ¦P¶µ¥Øªº¼Æ¶q!!!

lsoavme2

¦^´_ 6# ­ã´£³¡ªL

±z¦n¡AÁÂÁ±zªº¸ÑÄÀ¡C§Ú´N¤£¤ÓÀ´±z©Ôªº¨º­Ó½d³ò¡A©Ò¥H¤~¸ò±z½T»{¡C
ÁÂÁ±z~

nefertiitii

­YPO ªºattribute ¬O¼Æ¦r, ©Î³\¤]¥i¥H¥ÎRank...
eg: ¦bAF2 ¥´¤J¤½¦¡: Rank(AA2, AA$2:AA$34,1)
           AF3                   Rank(AA3,AA$2:AA$34,1)
           AF4                   Rank(AA4,AA$2:AA$34,1)
.....the rest in similar fashion.. good luck!