hcm19522

'=INDEX(C:C,RIGHT(SMALL(IF((MATCH($C$2C$12&$D$2D$12,$C$2C$12&$D$2D$12,)=ROW(C$2:C$12)-1)*($D$2D$12<>""),CODE(LEFT($C$2C$12))*100+ROW(C$2:C$12),4^8),ROW(A1)),2))&""

hcm19522

H15:H19=SUMIFS(H$2:H$12,C$2:C$12,E15,D$2:D$12,F15)
E15:F20=INDEX(C:C,RIGHT(SMALL(IF((MATCH($C$2:$C$12&$D$2:$D$12,$C$2:$C$12&$D$2:$D$12,)=ROW(C$2:C$12)-1)*($D$2:$D$12<>""),CODE(LEFT($C$2:$C$12))*100+ROW(C$2:$C$12),4^8),ROW(A1)),2))&""

hcm19522

E16:E20»PF16:F20¤@°_  g16¡Gg20ÃD·N¬O増 ©Ò¥H¤£¥Î¤½¦¡¥þ"増" (´î ¹ïÀ³¬OªÅ®æ) ª©¤j¤§·N¤£¥i¦æ ¦]­n§R­«½Æ
E16:F20«ö¦¸§Ç¨ú¸ê®Æ{=INDEX(C:C,RIGHT(SMALL(IF((MATCH($C$2:$C$12&$D$2:$D$12,$C$2:$C$12&$D$2:$D$12,)=ROW(C$2:C$12)-1)*($D$2:$D$12<>""),ROW(C$2:$C$12),4^8),ROW(A1)),2))&""
¸Õ¸Õ

hcm19522

F15:F19{=INDEX(D:D,SMALL(IF((MATCH(C$2:C$12&D$2:D$12,C$2:C$12&D$2:D$12,)=ROW(C$2:C$12)-1)*(D$2:D$12<>"")*(C$2:C$12=E15),ROW(C$2:C$12)),COUNTIF(E$15:E15,E15)))