- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 56
- ÂI¦W
- 0
- §@·~¨t²Î
- XP SP3
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2011-4-29
- ³Ì«áµn¿ý
- 2021-10-29
|
ÁÂÁ¦U¦ì¤j¤j¼ö¤ßªº¦^ÂСA¨ä¹ê·Qn±N
1.³o¤@¦æ xx="U3:U19" ¡A§ï¦¨ xx="U3:U" & ii (ii ¬°ÅܼÆ)¡C
2.µM«á ±N ³o¤G¦æµ{¦¡¡G
xx="U3:U" & ii
Range("N4") = "=MATCH(""" & arr_str_check(i) & """, " & xx & ",0)"
3.¦X¨Ö¦¨ ¤@¦æµ{¦¡(¦p¤U)¡G
Range("N6") = "=MATCH(""" & arr_str_check(i) & """, ""U3:U""" & ii & """,0)" '³o¤@¦æ¤@ª½¦³°ÝÃD
½Ð°Ý¤j¤j³o¤@¦æ¦p¦óקï¡A¥ýÁÂÁ¤j¤j ¼ö¤ßªº¦^ÂСC |
|