ªð¦^¦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.png
2019-5-28 10:59

test sample (3).zip (7.95 KB)

§ó·s

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

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 : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD