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

[µo°Ý] ¤j©ó0ªº¸ê®Æ¦Û°ÊÅã¥Ü

[µo°Ý] ¤j©ó0ªº¸ê®Æ¦Û°ÊÅã¥Ü

¤j¤j¦n,
B:GÄ欰²£«~®Ä´Áªº½LÂI
§Ú·QÅýB:GÄæ>0ªº¼Æ¶q(ªÅ¥Õ¤]µø¦P0,¤£Åã¥Ü),¤é´ÁÅã¥Ü¨ìHÄ椧«á,¦p¦P¸ê®Æ¤¤ªºH:JÄæ
½Ð°Ý¥i¥H¥Î¤°¨ç¼Æ¹F¦¨?
20191118.211104.jpg
2019-11-18 21:15


¤j©ó0ªº¸ê®Æ¦Û°ÊÅã¥Ü.rar (7.96 KB)

¤j©ó0ªº¸ê®Æ¦Û°ÊÅã¥Ü.rar (8.53 KB)

TOP

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

TOP

¦^´_ 2# zheng211016

·PÁÂ,
³o§¹¥þ¬O§Ú¤ß©Ò·Q....ÁÂÁÂ

TOP

¦^´_ 4# PJChen

¤£«È®ð ¦³°ÝÃD³£¥i¥Hµo°Ý §Ú¯àÀ°¦£³£·|ºÉ¶q §Ú¦Û¤v¤]·|¾Ç¨ì¤@¨Ç¸gÅç ^^

TOP

H3//°}¦C¤½¦¡:
=IFERROR(SMALL(IF(($B4:$G4>0)*($A3<>""),$B3:$G3),COLUMN(A$1)),"")  ¤U©Ô

®æ¦¡±ø¥ó:
B3: =B3/B4

TOP

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

­ã¤j,
°}¦C´ú¸Õ §¹¬ü
¦ý½Ð°Ý
®æ¦¡±ø¥ó:
B3: =B3/B4

¬O¤°»ò·N«ä? §Ú¸Õ¤£¥X¨Ó

TOP

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

­ã¤j,
½Ð±Ð¥t¤@¬Û¦P§@ªk,¦ýÅã¥Ü¤£¥Xµ²ªG,½ÐÀ°¦£¬Ý¤U
¦P¼Ë§Q¥Î½LÂI¼Æ¦r>0,Åã¥ÜB2:G2ªºµ²ªG
¬°¤°»ò¥Î°}¦CH4=IFERROR(SMALL(IF(($B4:$G4>0)*($A3<>""),$B$2:$G$2),COLUMN(A$1)),"")
«o¬OªÅ¥Õªº? §Ú·Q­nÅã¥Ü¦p¦P¹Ï¤ùªºµ²ªG
20191126.232736.jpg
2019-11-26 23:32

TOP

¦^´_ 8# PJChen


H4:
=IF(H3="","",INDEX($B$2:$G$2,MATCH(H3,$B3:$G3,)))

¦P®É¿ï¨ú¨â¦æ, ©¹¤U¶K¤½¦¡~~

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD