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

®æ¦¡¤Æ±ø¥ólimitation

®æ¦¡¤Æ±ø¥ólimitation

¦p°Êµe E1 ©M E2 ªº TEXT ¤£¤@¼Ë, ¥Î®æ¦¡¤Æ±ø¥ó·|Åã¥Ü爲­«½Æ.

½Ð°Ý¤j¤j¦p¦ó¸Ñ¨M³o­Ó°ÝÃD? ·PÁÂ.

sonny1.gif
ss

¥i¯à¬OEXCEL识别数­È¦ì数ªº­­¨î, §Ú«ö¤j¤j¤W­z数­È¥u«O¯d¤L¦ì¦Z¾Þ§@没¦³问题, 谢谢!
¥u¦³·Q¤£¨ìªº,
没¦³°µ¤£¨ìªº.

TOP

¦^´_ 2# flying008

¦³¤j¤jª¾¹D¸Ñ¨M¤èªk¶Ü¡H
ss

TOP

¦^´_ 3# sunnyso
³o¬O¦]¬°EXCEL¥ý¤Ñ­­¨î
­pºâºë·Ç¨ì²Ä15¦ì¼Æ¡A²Ä16¦ì¼Æ¶}©l³£µø¬°0
±ø¥ó®æ¦¡¥Î¤½¦¡§PÂ_
=SUMPRODUCT((MATCH($D$1:$D$4,$D$1:$D$4,0)=MATCH(D1,$D$1:$D$4,0))*1)>1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    thanks
ss

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD