excel¦Û°Ê±a¤J«ü©w§@·~°ÏªºÈ
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 118
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-5-22
|
¦^´_ 6# FAlonso
¾ãÓÅÞ¿è¦p¤U
x=COUNTA(Sheet1!$A:$A) pºâSheet1!AÄæ¸ê®Æ¶q
a=OFFSET(Sheet1!$E$1,1,,x,2) ¶Ç¦^Sheet1!E:FÄæ½d³ò
b=OFFSET(Sheet1!$A$1,1,,x,2) ¶Ç¦^Sheet1!A:BÄæ½d³ò
ar=IF(a<>0,ROW(b)*10+COLUMN(b),"") E:F½d³ò¦³¼ÆÈ´N¶Ç¦^¸ÓÀx¦s®æ¦C¦ì*10¥[¤W¦WºÙb½d³òªºÄæ¦ì¹ïÀ³È
¦]¬°n¨úE:F¤GÄæ¹ïÀ³Äæ¦ì¡A©Ò¥H¥ÎA:BªºÄæ¦ì¡A·|¬O1¡A2ªº²Õ¦X
¦p¦¹¤@¨Ó¦C¦ì*10+Äæ¦ì(1©Î2)´N·|¦³¤£¦P¤j¤pªºÈ¥X²{
y=INT(SMALL(ar,ROW(Sheet2!$A1))/10) pºâ¥X¦C¦ì
z=SMALL(ar,ROW(Sheet2!$A1))-y*10 §â¦C¦ì´î¥hªº¾l¼Æ´N¬OÄæ¦ì(«D1§Y2) |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|