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

[µo°Ý] ·s¤â¾Çexcel, 2­Ó°ÝÃD

[µo°Ý] ·s¤â¾Çexcel, 2­Ó°ÝÃD


²Ä¤@­Ó°ÝÃD: §Ú«ç¼Ë©â¥X¸ê®Æ¹³K¸òL¤@¼Ë


²Ä¤G­Ó°ÝÃD: «ç¼Ë¥i¥H§â¥»¨Ó¨S¦³ªº, ¥[¨ì¦Cªí

¥ý·PÁÂ
Book1.rar (8.22 KB)

SHEET1
K2:K17=IF(A2<>"",A2,"")
L2:L17{=IF(K2="",,SUM(IFERROR((A$2:A$17=K2)*(B$2:B$16-C$3:C$17),)))
SHEET2
E2:E9{INDEX(A:A,RIGHT(SMALL(LEFT(A$2:A$9)*100+ROW(A$2:A$9),ROW(A1)),2))
F2:F9{=INDEX(C:C,RIGHT(SMALL(LEFT(A$2:A$9)*100+ROW(A$2:A$9),ROW(A1)),2))

TOP

¦^´_ 2# hcm19522

¦n¹³¤£¦æ...¬O¤£¬O§Ú­þ¨½¥X¿ù

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD