- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¦^´_ 6# prince0413
¬O½d³ò
=IF(INDEX(¤u§@ªí2!$A$1:$AA$1,SMALL(IF(¤u§@ªí2!$A$1:$AA$1<>0,COLUMN($A$1:$T1),26),ROW(A1)))<>0,INDEX(¤u§@ªí2!$A$1:$T$1,SMALL(IF(¤u§@ªí2!$A$1:$T$1<>0,COLUMN($A$1:$T$1),26),ROW(A1))),"")
d2=OFFSET(¤u§@ªí2!$A$1,ROW(A1)+1,MATCH(¤u§@ªí1!$A$1,¤u§@ªí2!$A$1:$T$1,)-1)&""
e2=OFFSET(¤u§@ªí2!$A$1,ROW(B1)+1,MATCH(¤u§@ªí1!$A$1,¤u§@ªí2!$A$1:$T$1,))&""
¦WºÙ aa=¤u§@ªí1!$O$2:$O$9 |
|