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

[µo°Ý] ¨ç¼Æ_¦U³æÄ檺¥[Á`¼Æ~ª½±µ­°¾­±Æ§Ç&ÁY±Æ¡C

[µo°Ý] ¨ç¼Æ_¦U³æÄ檺¥[Á`¼Æ~ª½±µ­°¾­±Æ§Ç&ÁY±Æ¡C

TEST_1010.rar (2.75 KB)
³Æµù¡G
1_½Ð½ç±ÐExcel 2003ª©¥»ªº¨ç¼Æ¤½¦¡¡C
2_½Ð¤£­n¥Î»²§UÄæ¡C
ÁÂÁ¡I

»Ý¨D¡G

±NSUM(C2:C4),SUM(D2:D4),¡K¡K¡K,SUM(AX2:AX4),SUM(AY2:AY4)µ¥¦U³æÄ檺¥[Á`¼Æ¡A
ª½±µ¦bC5¥H¥Ñ¤j¦Ó¤p¨Ì§Ç©¹¥k±Æ§Ç¡F¨Ã©¹¥ª¶ñº¡¡C

½Ð°Ý¡GC5ªº¨ç¼Æ¤½¦¡¡H

¥H¤W  Àµ½Ð½ç±Ð¡I  ÁÂÁ¡I

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-10-10 11:04 ½s¿è

=LARGE(MMULT({1,1,1},$C2:$AY4*1),COLUMN(A1))

https://blog.xuite.net/hcm19522/twblog/590067264
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-10-10 17:04 ½s¿è

¦^´_ 2# hcm19522
±z¤Ó±j¤F
´ú¸Õ¦¨¥\
ÁÂÁ±zªºÀ°¦£©M«ü¾É~·P®¦

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-10-10 22:40 ½s¿è

¦^´_ 2# hcm19522
¤U¦C°ÝÃD~Àµ½Ð«ü¾É~ÁÂÁ±z
»Ý¨D¡G
¥HSUM(C2¡GC4),SUM(D2¡GD4),¡K¡K¡K,SUM(AX2¡GAX4),SUM(AY2¡GAY4)µ¥¦U³æÄ檺­°¾­±Æ§Ç¥[Á`¼Æ¡A
ª½±µ±N²Ä1¦Cªº¦PÄæ­ÈÅã¥Ü¦bC5¨Ã¥k©Ô¶ñº¡¡F¥B©¹¥ªÁY±Æ¡C
¸Ô¦pªþ¥ó : ¨ç¼Æ_¥H¦U³æÄæ¥[Á`­°¾­~Åã¥Ü²Ä1¦Cªº¦PÄæ­È¡C.rar (3.72 KB)

½Ð°Ý¡GC5ªº¨ç¼Æ¤½¦¡¡H

¥H¤W  Àµ½Ð½ç±Ð¡I  ÁÂÁ¡I

TOP

¦^´_ 4# ziv976688

{=RIGHT(LARGE(MMULT({1,1,1},$C2:$AY4/1%)+$C1:$AY1,COLUMN(A1)),2)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 5# hcm19522
hcm19522¤j¤j :
¤½¦¡Â²µu¤@¦¡§¹¦¨¥¿½T»Ý¨D~±z¯u¬O¤Ó±j¤Ó¼F®`¤F
ÁÂÁ±zªº­@¤ß«ü¾É©M¼ö¤ßÀ°¦£~·P®¦

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD