¤ÀÃþ²Î­p¤§°ÝÃD

s7659109

°ÝÃD¡G¥H¸ê²£Ä欰¥D¡A¨Ã«ö´Ú¶µÄæ¤À§O²Î­p°]²£¼W¥[¡A¨Ò¦p¬°A³]³ÆANDAAA°]²£¼W¥[¥[Á`¡A¨ä¥X²{ªºµ²ªG¦p¤U¡A¤½¦¡À³¦p¦ó¡H

s7659109

¥t¥~¥[¤JªÅ¦C3¦C¡A¥X²{NA,­Y¤½¦¡¦h«O¯dªÅ¥Õ¦C¡A¤½¦¡¦p¦ó­×¥¿¡H

s7659109

¥t¦³µo²{¡A·í²Ä1µ§§ï¦¨G³]³Æ¡A«h±Æ¦b²Ä1µ§¡AµLªk±Æ§Ç(«öA.....)¡A½Ð¨ó§U«öCÄæ±Æ§ÇA'B'C'D'E'F....

s7659109

¸Ñ¨M¤F¡AÁÂÁÂ!

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)))

s7659109

­ì¤½¦¡¥i¦æeøó¥i¦æ¡A·s­×§ï¦³°ÝÃD¡A¦ý§Úªº·N«ä¬O¥ý¶ñ¤JE16:E20«á¡A¦A¦Ò¼{¶ñ¤JF16:F20
±N­«½Æ©Ê½ð°£¡A¨äµ²ªG¦p«eªþÀÉ¡C

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))&""
¸Õ¸Õ

s7659109

½Ð°Ý¨ºf16:f20»Pg16¡Gg20¥i§_®Ú¾Úe16¡Ge20¦Û°Ê±a¤J©O¡H

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

'=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))&""