¦³Ãö¦Û°ÊÅܦâ¤Î³Ñ¾l¸ê®Æ°ÝÃD?
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
Hsieh¤j¤j¡G
¯à§_³Â·Ð±z¸ÑÄÀ¤@¤U{=INDIRECT("¶i³f«¬¸¹!A"&SMALL(IF((COUNTIF(¯S§O«¬¸¹!A:A,¶i³f«¬¸¹!$A$2:$A$7)=0)*(COUNTIF(¥X³f«¬¸¹!A:A,¶i³f«¬¸¹!$A$2:$A$7)=0),ROW($A$2:$A$7),""),ROW(A1)))}¸Ìªº¤½¦¡·N«ä...¦]¬°·Q¨ä¥Lªí®æ¤]¯à¾Ç¥HP¥Î....½Ð¤j¤j«üÂI...^^...¥t¥~¸Ì±ªºROW($A2:$A$7)¤ÎROW(A1)¬O«ü²Îpªº¼ÐÅҸ̶Ü.. ?? |
|
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
¥»©«³Ì«á¥Ñ jumky ©ó 2011-1-17 22:42 ½s¿è
¦^´_ 8# Hsieh
Hsieh¤j¤j..¤£¦n·N«ä...¦]¬°§A²Ä¤@¦¸poªº¤½¦¡¸ò²Ä¤G¦¸ªº¤£¤@¼Ë...§Ú¥H¬°³£¤@¼Ë´N¤@ª½¥Î±z²Ä¤@¦¸poªº....²{¦b¥i¥H¤F...ÁÂÁ±z....¤£¦n·N«ä.Åý±z¶O¤ß¤F... |
|
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
¦^´_ 6# Hsieh
Hsieh¤j¤j±z¦n¡G§Ú·Ó±z»¡ªº¾Þ§@³]®æ¦¡¤Æ±ø¥ó..¥i·í«ö¤U½T©w®É´N·|¥X²{¿ù»~°T®§.¦p¤U¡G
|
|
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
¦^´_ 4# Hsieh
Hsieh¤j¤j±z¦n¡G
§Ú¤w¸g·Ó±z»¡ªº©w¸q¦WºÙ..¥iÁÙ¬O¤@¼Ë¥X²{"¤£¯à¦b®æ¦¡¤Æªº·Ç«h¤¤°Ñ·Ó¨ì¨ä¥L¤u§@ªí©Î¬¡¶Ã¯"ªº°T®§?
§Ú§â¥Îªº©ñ¦bªþ¥ó...ÁٽФj¤j«üÂI...
Book1.rar (2.28 KB)
|
|
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
½Ð°ÝHsieh¤j¤j..
¬OÅý´å¼Ð°±©óA2Äæ¦ì,µM«á¦A¦Ü®æ¦¡/³]©w®æ¦¡¤Æ±ø¥ó¸Ìªº±ø¥ó¤@¿ï¾Ü¤½¦¡¬°...=COUNTIF(¥X³f«¬¸¹!$AA,$A2)>0¶Ü?..¥i¬O¥¦·|¥X²{"¤£¯à¦b®æ¦¡¤Æªº·Ç«h¤¤°Ñ·Ó¨ì¨ä¥L¤u§@ªí©Î¬¡¶Ã¯"ªº°T®§?
¥t¥~..¦b²Îp¿é¤J°}¦C¤½¦¡...¤W±«ö§¹ENTERÁ䤣·|¥X²{µ²ªG....´NÁÙ¬O¤½¦¡...??
¤£¦n·N«ä..§Ú¤Ó²Â¤F....¯à§_½Ð¤j¤j»¡©ú¸Ó¦p¦ó¾Þ§@¤~¹ï...?? |
|
|
|
|
|
|