- ©«¤l
- 91
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 130
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-5-14
- ³Ì«áµn¿ý
- 2020-5-17
|
·|¥X²{§A»¡ªºì¦]¬O¦]¬°¤½¦¡ªº³¡¤À A:A Åܦ¨¤å¦r
©Ò¥HnÅܦ¨¤â°Ê§ï
§Ú¤W¦¸¦^µª¦³»¡©ú
¤U±·s¤½¦¡¥i¥H§ïµ½³o°ÝÃD
{=INDEX(INDIRECT("'" & $C$2 & "'!" & LEFT(ADDRESS(1,COLUMN(A:A),4,1),LEN(ADDRESS(1,COLUMN(A:A),4,1))-1)&":"&LEFT(ADDRESS(1,COLUMN(A:A),4,1),LEN(ADDRESS(1,COLUMN(A:A),4,1))-1)),SMALL(IF(INDIRECT("'" & $C$2 & "'!$C$2E$200")=$B$2,ROW(B$2$200),4^8),ROW(B1)))}
½Ð´ú¸Õ¬Ý¬Ý |
|