¨D§U´M§ä²Ä¤Gµ§¸ê®Æªº¼gªk

yan2463

¨D§U´M§ä²Ä¤Gµ§¸ê®Æªº¼gªk
   ¥t¥i§_¥[§U»¡©ú
   (¦]¬°©|¦³¨ä¥L»Ý­n¹B¥Î) 1.rar (5.75 KB)

¤U¸ü¦¸¼Æ: 29

2013-9-25 13:39

yan2463

¦^´_ 15# ML089
·PÁÂ¥¿¦b¨Ï¥Î¤¤

ML089

¦^´_ 14# yan2463

C6
­ì¬°
=IF(COLUMN(B6)/3>COUNTIF(µûµ¥ªí!$A:$A,$B6),"",INDEX(µûµ¥ªí!$C:$E,MATCH($B6&"",µûµ¥ªí!$A:$A,)+INT((COLUMN(B6)-2)/3),MOD(COLUMN(B6)-2,3)+1))
§ï¬°
=IF(COLUMN(B6)/6>COUNTIF(µûµ¥ªí!$A:$A,$B6),"",INDEX(µûµ¥ªí!$C:$H,MATCH($B6&"",µûµ¥ªí!$A:$A,)+INT((COLUMN(B6)-2)/6),MOD(COLUMN(B6)-2,6)+1))

yan2463

¦^´_ 11# ML089
·Q¦A½Ð±Ð¤@­Ó°ÝÃD,·Q¼W¥[¸ê°T6Ä欰¤@²Õ,
À³¸Ó­×§ï¨º¸Ì

yan2463

¦^´_ 12# yan2463
¦A½Ð±Ð¤@­Ó°ÝÃD,­Y§Ú·Q§â¸ê°T¼W¥[¨ìHÄæ(6Ä欰¤@²Õ)
§Ú­n§ï¨º­Ó¦a¤è

yan2463

¦^´_ 11# ML089
¯uªº·PÁÂ,¤w§¹¥þ¥i¥H¥Î¤F

ML089

AF27¤½¦¡
=IF(COLUMN(A27)/3>COUNTIF(µûµ¥ªí!$A:$A,LEFT($T27,4)),"",INDEX(µûµ¥ªí!$C:$E,MATCH(LEFT($T27,4),µûµ¥ªí!$A:$A,)+INT((COLUMN(A27)-1)/3),MOD(COLUMN(A27)-1,3)+1))

¥k©Ô½Æ»s¤½¦¡

ML089

¦^´_ 9# yan2463

§AEXCELªí©Ò¥ÎªºC6¤½¦¡
=IF(COLUMN(B6)/3>COUNTIF(µûµ¥ªí!$A:$A,$B6),"",INDEX(µûµ¥ªí!$C:$E,MATCH($B6&"",µûµ¥ªí!$A:$A,)+INT((COLUMN(B6)-2)/3),MOD(COLUMN(B6)-2,3)+1))

§Ú­ìPOªº¤½¦¡
=IF(COLUMN(A2)/3>COUNTIF(µûµ¥ªí!$A:$A,$A2),"",INDEX(µûµ¥ªí!$C:$E,MATCH($A2&"",µûµ¥ªí!$A:$A,)+INT((COLUMN(A2)-1)/3),MOD(COLUMN(A2)-1,3)+1))

COLUMN(A2) ¬°­p¼Æ¾¹³Q§ï¬° COLUMN(B6) ·íµM·|®t¤@¦ì

C6¤½¦¡½Ð­×§ï¦p¤U
=IF(COLUMN(A6)/3>COUNTIF(µûµ¥ªí!$A:$A,$B6),"",INDEX(µûµ¥ªí!$C:$E,MATCH($B6&"",µûµ¥ªí!$A:$A,)+INT((COLUMN(A6)-1)/3),MOD(COLUMN(A6)-1,3)+1))

¥t¥~ª¬ªp¤­±ß¤@ÂI§Ú¦³ªÅ¦A¬Ý¬Ý

yan2463

1.rar (6.84 KB)

¤U¸ü¦¸¼Æ: 6

2013-10-1 08:59

¦^´_ 8# ML089
¤w¤W¶ÇÀÉ®×,¦A³Â·Ð¤F
¥tª¬ªp¤­¬O§_¥i¥HÀ°¦£¸Ñµª

ML089

¦^´_ 7# yan2463

§Ú¸Õ¹L¤£·|¦³¦¹°ÝÃD ?
½Ð±NÀÉ®×PO¤W¨Ó¬Ý¬Ý