ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý¤@¦¸¦^¶Ç¦h­Ó¦C¸¹ªº¤èªk

½Ð°Ý¤@¦¸¦^¶Ç¦h­Ó¦C¸¹ªº¤èªk

½Ð°Ý¦U¦ì«e½ú :
        AÄ橳¤U¤À§G¤F´X­Ó"FALSE",§Ú·Q­n¦^¶Ç©Ò¦³"FALSE"Àx¦s®æªº¦C¸¹¡C
¥Î =MATCH(FALSE,A:A,) ¡A¥u¯à¶Ç¦^²Ä¤@­Ó¿ù»~ªº¦C¸¹¡A½Ð°Ý­n¦p¦ó°µ¤~¯à¤@¦¸¦^¶Ç©Ò¦³¿ù»~ªº¦C¸¹ ?

¦^´_ 1# chen031695

¬¡°Ê¼s§i:
1.µo°ÝªÌ½Ð¤W¶ÇEXCELÀ£ÁYÀÉ(¤p¾Ç¥Í¤]¥i¥H)
2.°t¦XEXCELÀɽЧâ¥\¯à»¡©ú²M·¡


B1=IF(A1="","",IF(A1=FALSE(),ROW(),""))
©Î
C1=IF(SMALL(IF(ISLOGICAL($A$1:$A$65535)*($A$1:$A$65535<>TRUE()),ROW($1:$65535),65536),ROW(1:1))<65536,SMALL(IF(ISLOGICAL($A$1:$A$65535)*($A$1:$A$65535<>TRUE()),ROW($1:$65535),65536),ROW(1:1)),"")
°}¦C¤½¦¡

TOP

ÁÂÁ 2¼Ó¤j¤jªº±Ð¾É¡A²Ä¤G²Õ¤½¦¡À°¤F§Ú«Ü¤jªº¦£¡A¸`¬Ù«Ü¦h®É¶¡¡C
¦³¿ìªk¯à§â¿ù»~ªº¦C¸¹¶°¤¤¦b¦P¤@­ÓÀx¦s®æÅã¥Ü¥X¨Ó¶Ü ?
¨Ò¦p : AÄ檺²Ä 123¦C »P 456¦C¬Ò¬°FALSE¡A¯à°÷¦b B1¨q¥X 123,456 ¶Ü ?

TOP

¦^´_ 3# chen031695

¤º«Ø¤å¦r¨ç¼ÆµLªkµ²¦X°}¦C
¥ý«Ø¥ß2­Ó¦WºÙ
x¤½¦¡
=OFFSET(¤u§@ªí1!$A$1,,,COUNTA(¤u§@ªí1!$A:$A),)
y¤½¦¡
=SMALL(IF(x=FALSE,ROW(x),""),ROW(INDIRECT("A1:A"&COUNTIF(x,FALSE))))
¨Ï¥Î¦Û©w¸q¨ç¼Æ
¤@¯ë¼Ò²Õ
  1. Function JoinIIF(Rng As Variant, dot As String) 'µ²¦X°}¦C¤¸¯À
  2. Dim Ar(), a As Variant
  3. For Each a In Rng
  4.     ReDim Preserve Ar(s): Ar(s) = a: s = s + 1
  5. Next
  6. JoinIIF = Join(Ar, dot)
  7. End Function
½Æ»s¥N½X
¥¼©R¦W.png
2012-4-19 00:01

Àx¦s®æ¤½¦¡=JoinIIF(y,",")
¥¼©R¦W.png
2012-4-19 00:02
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ Hsiehª©¤j¡A¤p§Ì§Ú¨ü±Ð¤F¡C

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD