- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 254
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-23
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-9-30 18:08 ½s¿è
¦^´_ 7# hsien33
§R°£Àx¦s®æ·|³y¦¨©w¸q°Ñ·Ó¿ù»~§ï¥ÎINDIRECT«ü©w½d³ò
A=INDEX(INDIRECT("¸ê®Æ!$A:$A"),MATCH(²Îp!$B$2,INDIRECT("¸ê®Æ!$A:$A"),0)+3,1) §ä¨ì¸Ó©m¦Wªº²Ä¤@¦C¸ê®Æ¦ì¸m
B=OFFSET(A,MATCH("¤pp",A:INDIRECT("¸ê®Æ!$A$65536"),0)-2,) ¸Ó©m¦W¸ê®Æ½d³ò²Ä¤@¦C¸ê®Æ¦ì¸m¦V¤U§ä¨ì²Ä¤@Ó"¤pp"¦V¤W1®æ(¸ê®Æ³Ì«á¤@µ§¦ì¸m)
P=MATCH("«O¶O¤pp",OFFSET(A,-2,,,256),0) ¸Ó©m¦W¸ê®Æ½d³ò¼ÐÃD¬°"«O¶O¤pp"ªº¦ì¸m
Rng=OFFSET(A,,,ROW(B)-ROW(A)+1,) AÄæ¸ê®Æ½d³ò
Rng1=OFFSET(A,,P-1,ROW(B)-ROW(A)+1,) "«O¶O¤pp"Äæ¦ì¸ê®Æ½d³ò
¤£¹L§Ú»{¬°n±N¸ê®Æ¾ã²z¦¨¦p¤U¹Ïªº¸ê®Æ®w¦A¨Ópºâ·|¤ñ¸û¦n
A=INDEX(INDIRECT("¸ê®Æ!$A:$A"),MATCH(¤u§@ªí1!$A3,INDIRECT("¸ê®Æ!$A:$A"),0)+3,1) §ä¨ì¸Ó©m¦Wªº²Ä¤@¦C¸ê®Æ¦ì¸m
B=OFFSET(A,MATCH("¤pp",A:INDIRECT("¸ê®Æ!$A$65536"),0)-2,) ¸Ó©m¦W¸ê®Æ½d³ò²Ä¤@¦C¸ê®Æ¦ì¸m¦V¤U§ä¨ì²Ä¤@Ó"¤pp"¦V¤W1®æ(¸ê®Æ³Ì«á¤@µ§¦ì¸m)
P=MATCH(¤u§@ªí1!C$1,OFFSET(A,-2,,,256),0)+IF(¤u§@ªí1!C$1="´«ºâ«O¶O¤pp",0,MOD(COLUMN()-3,3)) ¸Ó©m¦W¸ê®Æ½d³ò¼ÐÃD¬°"«O¶O¤pp"ªº¦ì¸m
Rng=OFFSET(A,,,ROW(B)-ROW(A)+1,) AÄæ¸ê®Æ½d³ò
Rng1=OFFSET(A,,P-1,ROW(B)-ROW(A)+1,) "«O¶O¤pp"Äæ¦ì¸ê®Æ½d³ò
¤À°Ï¥[Á`.rar (11.89 KB)
|
|