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

[µo°Ý] ¬d°Ýexcel ¤½¦¡

[µo°Ý] ¬d°Ýexcel ¤½¦¡

¥»©«³Ì«á¥Ñ john2006168 ©ó 2019-5-28 11:05 ½s¿è

·Q½Ð°Ý¤@¤Uexcelªº¤½¦¡¹B¥Î.? test sample (3).zip (7.95 KB)

test sample (3).zip (7.95 KB)

§ó·s

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-5-31 16:40 ½s¿è

®ÄªG¤@
C13:  {=IF(1>COUNTA(D3:D9),"",INDEX(D:D,SMALL(IF($D$3:$D$9<>"",ROW($D$3:$G$9)),1)))}
D13: {=IF(2>COUNTA(D3:D9),"",INDEX(D:D,SMALL(IF($D$3:$D$9<>"",ROW($D$3:$G$9)),2)))}
¾l¨Ì¦¹­ì«hCOPY­×§ï
®ÄªG¤G
C22: =SUM(D3:D9)
¾l¨Ì¦¹­ì«hCOPY­×§ï
ù

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD