¦³Ãö¦Û°ÊÅܦâ¤Î³Ñ¾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
¤½¦¡¸ÌROW(A1)¬O«üþ¸Ì..?ÁÙ¦³¨C¦¸¶}³oÓÀÉ®×®É...¥¦³£·|¦Û°Ê«ºâÀx¦s®ænµ¥«Ü¤[....½Ð°Ý¸Ó¦p¦ó¥[§Ö¥¦ªº³t«×? |
|
|
|
|
|
|
- ©«¤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
ROW(A1)¬O«ü¶i³f«¬¸¹¸ÌªºA1...ÁÙ¬O²Îp¼ÐÅҸ̪ºA1...?
¨S¿ù¬O¨Ï¥Î°}¦C¤½¦¡©Ò¥HÅܱo½wºC....¥i¥¦¥²¶·¨Ï¥Î°}¦C¤½¦¡¤~¯à«·spºâ...¦Ó¨C¦¸¶}¦¹ÀÉ...´N·|¶]«Ü¤[...¨C°µ¤@Ӱʧ@¤]·|¶]«Ü¤[....³s±a¨ä¥L¶}±ÒªºEXCELÀɤ]·|Åܱo°Ê§@½wºC....½Ð°Ý¦³¤°»ò¤èªk¥i¥HÁקK¦¹±¡§Îµo¥Í...?? |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¦^´_ 13# jumky
{=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)))}
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),"")
³o¬q¬O¦pªG¶i³f«¬¸¹!$A$2:$A$7¨S¥X²{¦b¯S§O«¬¸¹!AÄæ¦Ó¥B¶i³f«¬¸¹!$A$2:$A$7¤]¨S¦b¥X³f«¬¸¹!AÄæ´N¶Ç¦^$A$2:$A$7ªº¦C¸¹¡A§_«h¶Ç¦^ªÅ¥Õ
³o·|²£¥Í¤@Ó2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C
§Q¥ÎSMALL¨ç¼Æ¨ú¥X¥Ñ¤p¨ì¤jªº¼Æ¦r¡ASMALL·|©¿²¤¤å¦r
ROW(A1)Y¦V¤U½Æ»s·|±qA1Åܬ°A2¡AA3¡AA4......
³o´N¬OSMALLªº²Ä2ӰѼÆ
ROW(A1)¶Ç¦^1´N¬O¨ú2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C¤¤ªº³Ì¤pÈ
ROW(A2)¶Ç¦^2´N¬O¨ú2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C¤¤ªº²Ä¤G¤pÈ
¥H¦¹Ãþ±À
³Ì«á¨Ï¥ÎINDIRECT¨ç¼Æ«ü¨ìÀx¦s®æ
"¶i³f«¬¸¹!A"¬O»¡n«ü¨ì¶i³f«¬¸¹!AÄæ
SMALL¨ú±oªºÈ´N¬O¦C¸¹
¨Ò¦p
2~7ªº¼Æ¦r»PªÅ¦r¦êªº°}¦C¤¤³Ì¤pȬO3
¨º»ò
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¶Ç¦^3
°t¦X "¶i³f«¬¸¹!A"&
´N±o¨ì¦r¦ê"¶i³f«¬¸¹!A3"
©Ò¥H¸ÓÀx¦s®æ´N·|±o¨ì¶i³f«¬¸¹!A3ªºÈ |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤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-27 23:45 ½s¿è
¶â...¤F¸Ñ..ÁÂÁÂHsieh¤j¤j¸Ô²Ó¸Ñ»¡...^^¤£¦n·N«ä,¦A¦¸½Ð°Ý¤j¤j,¦]¬°§Ú¨Ï¥Î°}¦C¤½¦¡ªº¸ê®Æ¦³±Nªñ200µ§..¬O§_¦]¨Ï¥Î¤F¹L¦h°}¦C¤½¦¡...¾ÉPexcel«ºâÀx¦s®æ®É¾ãÓ¤å®Ñ³B²z§@·~½wºC...´N³s¦sÀɤ]¹³·í¾÷¤@¼Ë....??½Ð°Ý¬O§_¦³¸Ñ¨M¤èªk,¯à¨Ï¥Î¸Ó¤½¦¡¤S¤£P©óÅýexcel¤@¶}±Ò´N²£¥Í§@·~½wºC²{¶H..?? |
|
|
|
|
|
|
- ©«¤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-28 13:52 ½s¿è
¶â...ÁÂÁÂHsieh¤j¤j....^^...¨º½Ð°Ý¦pªG¤£¥Î°}¦C¤½¦¡¥Î»²§UÄæ...¸Ó¦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
|
|
|
|
|
|
|