¨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

Hsieh

¦^´_ 1# yan2463

¤U¸ü (22.21 KB)

2013-9-28 00:34

B2°}¦C¤½¦¡
=INDIRECT("µûµ¥ªí!R"&SMALL(IF(--µûµ¥ªí!$A$4:$A$39=°ÝÃD¤G!$A$2,ROW($4:$39),""),INT((COLUMN()-2)/3)+1)&"C"&COLUMN()+1-INT((COLUMN()-2)/3)*3,0)   

¨ä¤¤
SMALL(IF(--µûµ¥ªí!$A$4:$A$39=°ÝÃD¤G!$A$2,ROW($4:$39),""),INT((COLUMN()-2)/3)+1)
·|¨ú±o²Å¦X±ø¥óªº²Ä?¤p¦C¸¹
¦]¬°B:DÄ欰²Ä¤@µ§¸ê®Æ©Ò¥H¥ÎINT((COLUMN()-2)/3)+1¨Ó¨ú±o
¦Ü©ó¤Þ¥Î¨ìINDIRECT°Ñ¼Æ³¡¤À¡A¦³¦C¸¹«á´N¥u­n¤TÄæ¤@²Õ¨Ã¥H3¡B4¡B5¬°Ä渹
COLUMN()+1-INT((COLUMN()-2)/3)*3
³o¼Ë´N¯à¦V¥ª¥H3¡B4¡B5¡B3¡B4¡B5....³o¼Ë±Æ¦C¤F

ML089

B2 ¤@¯ë¤½¦¡ (·íªÑ²¼¦³±Æ¦C¦b¤@°_®É)
=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))

¥k©Ô½Æ»s¤½¦¡(¦³´Xµ§»Ý¨D´N¥k©Ô´Xµ§)

yan2463

·PÁ¨â¦ì´£¨Ñªº¤èªk
¥¿¦b¨Ï¥Î¤¤

yan2463

½Ð°Ýª¬ªp¤­¤¤¥N¸¹¤Î¤å¦r
¦p¦ó¤~¯à¥Î¦¹¤½¦¡

yan2463

¦^´_ 2# Hsieh
·PÁ§Aªº¸Ñµª,¦ý¬O§ÚÁÙ¬O¤£À´吔
¥i§_¦A±Ð§Úª¬ªp¤Gªº¼gªk

yan2463

¦^´_ 3# ML089
½Ð°Ý§Ú¸Õ¥Î§Aªº¤èªk®É,
¦pªGµûµ¥ªí¤¤¸ê®Æ¥u¦³¤@µ§®É,³Ì«á¤@Äæ(¥Ø¼Ð»ù)¸ê®Æ·|±a¤£¥X¨Ó
¦pªG¥u¦³¨âµ§®É,²Ä¤Gµ§¸ê®Æ,³Ì«á¤@Äæ(¥Ø¼Ð»ù)¸ê®Æ·|±a¤£¥X¨Ó

ML089

¦^´_ 7# yan2463

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

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

¦^´_ 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¬Ý¬Ý