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

[µo°Ý] ¨Ì¹F¦¨²v¼Æ¾Ú¥­§¡¤À°t¨ú¾ã¼Æª÷ÃB...

[µo°Ý] ¨Ì¹F¦¨²v¼Æ¾Ú¥­§¡¤À°t¨ú¾ã¼Æª÷ÃB...

¨Ì¹F¦¨²v¼Æ¾Ú¥­§¡¤À°t¨ú¾ã¼Æª÷ÃB...
1.¨ú¹F¦¨²vÁ`­p¼Æ¾Ú(G96Àx¦s®æ 3850994)
2.¹êµo¼úª÷¬°¹F100%ªÌ
3.­pºâ¹êµo¼úª÷¬°:¹F¦¨²vÁ`­p¼Æ¾Ú3850994/¹êµo¼úª÷1000000*¨C¦ì¹F¦¨¼Æ¾Ú)



­«­n´£¿ô¬O
¹êµo¼úª÷»Ý¬°¾ã¼Æ¥B¹êµo¼úª÷¦X­pÁ`­p»Ý¬°1000000
¸Ó¤½¦¡¸Ó¦p¦ó³B²z...(¤~¤£·|»~®t1~2¤¸)

0214.rar (8.61 KB)

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

·PÁª©¥D²Ó¤ß¸Ñ»¡
¹ï©ó¤½¦¡¹B¥Î¤§¬¡¥Î»P²z¸Ñ
ºÃ´b¤£¸Ñ¤§³B§¡¯àªï¤b¦Ó¸Ñ...·P®¦   ^^

TOP

¦^´_ 11# cypd


¬Oªº, ¤§«e¦]§t"¥»´L", ¬G¶·´î-1

TOP

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

¯u¬O¤Ó¯«©_¤F...^^

³o¼Ë§¹¬üªº¤½¦¡¤w¸g±N°ÝÃD§¹¾ã³B²z§e²{©Ò»Ý¼Æ¾Ú...·P®¦

½Ð°Ý«e­z¤½¦¡¤¤  COUNTIF(G$1:G2,G2)-1 »P¥»¦¸¤½¦¡  COUNTIF(J$4:J4,J5)

¸Ì­±ªº  COUNTIF=¡]½d³ò,±ø¥ó¡^...¨ä¤¤¨âªÌÀx¦s®æ¦]¦ì¸m¤£¦P¤Ö¤F  -1 ¬O?

TOP

¦^´_ 9# cypd


=IF(K5="","",ROUND(K5/K$99*L$3,)+(RANK(J5,J$5:J$98)+COUNTIF(J$4:J4,J5)<=ABS(L$2))*SIGN(L$2))

TOP

¦^´_ 6# ML089

·PÁª©¥D...
°ÝÃDÂI¤w­«·s¤W¶Ç¸É±Ô»¡©ú...

TOP

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

­Yµw­n¤½¦¡ª½±µ¹F¦¨(¤£ºÞ¦hÁÙ¬O¤Ö, ³£¥Ñ²Ä¤@¦W©¹¤U¥[´î...³o´N¬O§Ú§Æ±æªºµ²ªG)
j1//¥ý¨ú±o®t²§¼Æ:
=I1-SUMPRODUCT(ROUND((0&G2:G95)/G96*I1,))

·PÁª©¥Dªº¦^´_  ^^
°w¹ï°ÝÃD¦]¨S¦Ò¶qªí¹F²M·¡...
1.°w¹ï­pºâ¼úª÷¨Ì¾Ú»Ý°Ñ¦Ò  J5:J88 ªº¹F 100%¤§¼Æ¾Ú
  ( K Äæ¹F100%¼Æ¾Ú¨t°Ñ¦Ò·~ª÷ÁZ®Ä©Ò­pºâ...»P¹ê»Ú J Äæ¹F100%±Æ§Ç¦³»~®t¡A³y¦¨¹êµo¼úª÷µ¹¿ù)

2.­pºâ¼úª÷Äæ¦ì(L5:L98)¤§¤½¦¡¸Ó¦p¦ó­«·s­×¥¿?
0217.rar (12.37 KB)

TOP

¦^´_ 5# cypd

1) ¤â°Ê¥[´î¬O³Ì¦n¤èªk
2) ®t¼Æ¥i¯à¦h¤]¥i¯à¤Ö
3) ±Æ¦W¥i¯à¦P¦W¦³¦h¤H, ¦p®t¼Æ2, ¦ý²Ä¤@¦W¦³3­Ó, ¤S¶·¦h¤@¹D­pºâ

­Yµw­n¤½¦¡ª½±µ¹F¦¨(¤£ºÞ¦hÁÙ¬O¤Ö, ³£¥Ñ²Ä¤@¦W©¹¤U¥[´î)
j1//¥ý¨ú±o®t²§¼Æ:
=I1-SUMPRODUCT(ROUND((0&G2:G95)/G96*I1,))

h2//
=IF(G2="","",ROUND(G2/G$96*I$1,)+(RANK(G2,G$2:G$95)+COUNTIF(G$1:G2,G2)-1<=ABS(J$1))*SIGN(J$1))

TOP

¦^´_ 5# cypd

­Y¬O¥H»~®t¬O-2®É¡A¤S¸Ó«ç»ò¤À°t?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ­ã´£³¡ªL
·PÁ±zªº»¡©ú
­Y¬O°ÝÃD§Æ±æµ²ªG¯à¥H¹F¦¨²v³Ì¨ÎªÌ¬°²Ä¤@Àu¥ýªº¦Ò¶q
¤½¦¡¬O§_¥i¦æ(­Y¥H»~®t2¬°¨Ò...¹F¦¨²v³Ì¨ÎªÌ²Ä¤@¦W¸É1,²Ä¤G¦W¤]¸É1ªº¤è¦¡...¥H¦¹Ãþ±À)

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD