·Q½Ð°Ý~INDIRECT ©M MATCHªº°ÝÃD
- ©«¤l
- 1
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- Professional
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-12-1
- ³Ì«áµn¿ý
- 2012-12-1
|
·Q½Ð°Ý~INDIRECT ©M MATCHªº°ÝÃD
·Q½Ð°Ý¦U¦ì¤jô~
=INDIRECT("'"&$A3&"'!r"&$B3&"C"&COLUMN(B$1),FALSE)
=MATCH(' '!$A$2,INDIRECT("'"&A3&"'!A:A"),0)
=INDIRECT("'"&$A3&"'!r"&$B3&"C"&COLUMN(C$1),FALSE)
³o¥yªº·N«ä¬O¬Æ»ò©O??
¥i§_³Â·ÐÅý¤p§Ìª¾¹D¸ÌÀYªº²[¸q?
ÁÂÁÂ!! |
|
|
|
|
|
|