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

[µo°Ý] excel¯à°÷ªí¥Ü¥XDÄ檺¼Æ¦r¶Ü?

[µo°Ý] excel¯à°÷ªí¥Ü¥XDÄ檺¼Æ¦r¶Ü?

¥»©«³Ì«á¥Ñ pianoand ©ó 2016-1-15 09:41 ½s¿è

«ô°U¤j¤j¸Ñ´b...

¤wª¾:1A¬V¦âÅé.
         2.B¬V¦âÅé.
         3.¤w¸g³Q©T©wªº°Ï¬q

¥Øªº:excel¯à°÷ªí¥Ü¥XDÄ檺¼Æ¦r¶Ü?
¥Ø«e¬Ý¨ìªº¬O¤H¤u¼g¥Xªº¸Ñµª¡A¯à§_¥Î¤½¦¡±a¤J©O

ÁÂÁÂ

Á|¨Ò»¡©ú¦bÀɮ׸Ì
002.zip (6.79 KB)

¦^´_ 1# pianoand
¬Ý¤£À´¡AÅÞ¿è½Ð»¡©ú²M·¡¡C
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¢Ò¢±¡D°}¦C¤½¦¡¡G
=IF(C2<>"",C2,INDEX(B:B,MATCH(1=1,ISNA(RANK(B$2:B$11,(C$2:C$11,D$1:D1))),)+1))

TOP

¦^´_  pianoand
¬Ý¤£À´¡AÅÞ¿è½Ð»¡©ú²M·¡¡C
stillfish00 µoªí©ó 2016-1-15 09:52



ÁÂÁ¤j¤j­@¤ßªº²z¸Ñ!
½Ð°Ý¤j¤j¯à²z¸Ñªí®æùØEÄ檺¸ÑÄÀ¶Ü?

TOP

¦^´_ 3# ­ã´£³¡ªL
¤Ó±j¤F¡A§Úµoı§Ú¦³¤½¦¡»Ùê¡C
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 5# stillfish00


¤½¦¡¡Dµ{¦¡¡A±z¬O¨â±o¯q¹ü¡A²ö¤Ó«È®ð¤F¡I
¡@
¦³®É¹J¨ì»Ý¨D»¡©ú±o¨¥Â²·N¤£²M¡AÁ`­n¥ý±ÀºV¤@µf¡ã¡ã

TOP

¸É¥R»¡©ú...

AÄæBÄ欰¸ê®Æ®w
­n§¹¦¨DÄæ

DÄæ³Q­n¨D
1.¶À®Ø³¡¤À­n¸òAÄæ¶À®Ø³¡¤Àªº¦ì¸m¸ò¼Æ¦r¤£ÅÜ
2.¨ä¾l³¡¤À¶ñ¤JBÄæ³Ñ¤Uªº¼Æ¦r¡A¦ý­n¨Ì¾ÚBÄ檺¥X²{¶¶§Ç¨Ì§Ç¶ñ¤J
  ¤w¥X²{¦b¶À®Øªº¼Æ¦r´N¸õ¹L¤£¶ñ

TOP

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


ÁÂÁ¤j¤jªº¦^ÂÐ

¥J²Ó±ÀºV¤¤

TOP

D2:D11{=IF(C2="",INDEX(B:B,SMALL(IF(COUNTIF(C$2:C$11,B$2:B$11)=0,ROW(B$2:B$11)),SUM((C$2:C2="")*1))),C2)

TOP

[quote]D211{=IF(C2="",INDEX(B:B,SMALL(IF(COUNTIF(C$2:C$11,B$2:B$11)=0,ROW(B$2:B$11)),SUM((C$2:C2="")*1))) ...
hcm19522 µoªí©ó 2016-1-15 16:36 ÁÂÁ¤j¤j
   
ÁÂÁ¤j¤j.¤p§ÌÁÙ¦b¸Õ

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD