- ©«¤l
- 3
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 5
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 000
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-8-5
- ³Ì«áµn¿ý
- 2017-9-5
|
¦U¦ì«e½ú¡A²Ä1¦¸µo°Ý¡A¦p¦³¤£©PÁٽШ£½Ì¡A
¤p§Ì·Q½Ð°Ý¤@Ó°ÝÃD
ªþ¥óÀɮפ¤ª©°tµ¬³oÓ¬¡¶¸Ì¡AQ8³oÓÀx¦s®æ²zªº¤½¦¡¬°
Q8=VLOOKUP($P$6,CHOOSE({1,2},INDIRECT("¸ê®Æ®w!$F"&ª©°tµ¬!$R$4&":$F"&ª©°tµ¬!$Q$9),ROW(INDIRECT("¸ê®Æ®w!$F"&ª©°tµ¬!$R$4&":$F"&ª©°tµ¬!$Q$9))),2,FALSE)
¨ä¥Øªº¬°¦b¸ê®Æ®w¸Ì§ä¥X®É¶¡¤¶©óP2»PQ2¶¡¥Bµ²ºc³¡¦ì¬°ª©¤§²Ä¤@µ§¸ê®Æ©Ò¦b¤§¦C¸¹¡C
¦ý¿ï¨úQ8¤½¦¡¤Ï¥Õ«á«öF9Áä¡A©ÒÅã¥Ü¤½¦¡µ²ªG¬°6¡A»PÅã¥ÜȬ°5¤£¦P¡C
¤p§Ì·Q¯}¸£³U¤´µLªk§JªA¡A´N³sA13Àx¦s®æ¤]¬O¦P¼Ë±¡ªp
A13=IF(OR(A12="",A12=$Q$9),"",IF($N$1=1,IF(A12=$R$5,"",A12+1),IF($N$1=2,VLOOKUP($P$6,CHOOSE({1,2},INDIRECT("¸ê®Æ®w!$F"&ª©°tµ¬!$A12+1&":$F"&ª©°tµ¬!$Q$9),ROW(INDIRECT("¸ê®Æ®w!$F"&ª©°tµ¬!$A12+1&":$F"&ª©°tµ¬!$Q$9))),2,0))))
½Ð¦U¦ì«e½ú·í§Ú¸Ñµª¡A·PÁÂ! |
-
-
(TEST) .rar
(44.32 KB)
|