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

¨ç¼Æ°ÝÃD (ÁÂÁÂ)

¨ç¼Æ°ÝÃD (ÁÂÁÂ)

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-7-13 01:32 ½s¿è

³Â·Ð¼Ó¤W¤j¤jÀ°¦£

³]©óA1~A10½d³ò¤º¡A¬Y¤@®æ¤º®e¬°"±Æ°©ÄÑ"¡A¨ä¥L®æ¤º®e¬Ò¬°"false"¡C
§Ú·Q¦bC1¨q¥X"±Æ°©ÄÑ"¡C

½Ð°Ý¼gªk¡A¸U¤À·PÁ¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

=LOOKUP(CHAR(65535),A1:A10)

TOP

«D±`·PÁ ANGELA ¤j¤j¡A³o¸Ìµ¹±z¤j¤jªº·P®¦³á¡I
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

=LOOKUP(CHAR(65535),A1:A10)
ANGELA µoªí©ó 2011-5-17 13:22



    °ª¤â¡A«Ü©_§®ªº¤½¦¡
¦b¤U²z¸Ñ¤£¤F¤½¦¡ªº§t·N¡A¯à»¡©ú¤@¤U¶Ü

TOP

CHAR(65535)¥Ø«e¥¦¨S¦³¤å¦rªº,¦ý¥¦ªº­È¬O©Ò¦³¤å¦r³Ì¤jªº,
»P¼Æ¦rªº9.9e+307¬Û¦P·N«ä.

TOP

¦hÁ«ü±Ð¡A³oÂI§Úª¾¹D¡A¦ý¤£ª¾¹D¥H¤U¡G
1.¦pªGa1:10¸Ì­±¬O¤£¦Pªº¦r¥À¡A­n¨ú¨ä³Ì¤j¦r¥À¥X¨Ó
2.¦pªGa1:10¸Ì­±¦³­^¡B¼ÆÁÙ¦³­Ó¤¤¤å¦r²VÂø¡A­n¨ú¨ä¤¤¤å¦r¥X¨Ó
³o¼Ë¤½¦¡«ç»ò³]¡H½ÐÄ~Äò«ü±Ð

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-5-18 11:56 ½s¿è

§Aªº°ÝÃD¸ò¥Lªº°ÝÃD¤£¦P,¥L¦³´£¨ì¨ä¥LÀx¦s®æ³£¬OFALSE.
§Aªº°ÝÃD¥ú¥ÎLOOKUP µLªk³B²z.
¨ú¥X¤j¼g¦r¥À=CHAR(MAX(IF((CODE(A1:A10)>64)*(CODE(A1:A10)<91),CODE(A1:A10))))
¨ú¥X¤¤¤å¦r    =CHAR(MAX(IF(CODE(A1:A10)>42047,CODE(A1:A10))))
³£¬O°}¦C¤½¦¡

TOP

¦hÁ«ü±Ð¡A§Úªí¹F±o¤£¦n¡A§Úªº¥Øªº¬O¨ú¥X³o¤@Ä檺code½Xªº³Ì¤j­È

TOP

=MAX(CODE(A1:A10))°}¦C
¬O³o¼Ë¶Ü?

TOP

­ì«h¤WÁcÅ餤¤åªº¦r¤¸½X·|¤j©ó255
©Ò¥HCODE¤j©ó255«hÄݤ¤¤å¦r
¦ý²Å餤¤å¦bÁcÅ骩¤¤³£¬OCHAR(63)="?"
¤£¹L¡AEXCEL¤¤¤å¦rªº±Æ§Ç¨Ã«D¥H¦r¤¸½X±Æ§Ç¡A¥¿½T±Æ§Ç­ì«h¬O¥Hµ§µe¬°·Ç«h¡A¦Pµ§µe®É¦A¥H¤º½X±Æ§Ç
©Ò¥H¡A­n§ä¥XÀx¦s®æ¤º²Ä¤@­Ó¦r¦ê¬OÁcÅ餤¤å
°}¦C¤½¦¡
=IF(ROW(A1)>SUMPRODUCT((CODE($A$1:$A$10)>255)*1),"",INDEX($A$1:$A$10,SMALL(IF(CODE($A$1:$A$10)>255,ROW($1:$10),""),ROW(A1))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD