ÔÚexcelÖÐɸѡABABÀàβºÅ

¼Ù¶¨ºÅÂëÔÚAÁУ¬¿ÉÔÚB1ÊäÈ빫ʽ£º=IF(OR(LEFT(RIGHT(A1,4),2)=RIGHT(A1,2),(LEFT(RIGHT(A1,4))=LEFT(RIGHT(A1,3)))...


ÎÒÓÐÒ»ÅúÊÖ»úºÅÂë,ÇëÎÊÈçºÎÔÚEXCEL°ÑÊÖ»úβÊýABAB,AABB,AAA...

=RIGHT(RIGHT(A1,4),2),A1,"")))ÔÚB1µ¥Ôª¸ñÊäÈëÉÏÃæÕâ¸ö¹«Ê½£¬È»ºó°´×¡¹«Ê½ÏÂÀ­¸´ÖƵ½ÐèÒªµÄλÖã¬ÕâÑùBÁоÍÊÇÄãÐèÒªµÄö¦ºÅ¡£


excelÔõÑù²éÕÒababÐÎʽ

=IF((MID(A1,1,1)=MID(A1,3,1))*(MID(A1,2,1)=MID(A1,4,1)),"abab","")¹«Ê½ÏÂÀ­ ...


ÓÃExcel±í¸ñÓï¾ä,¶Ô8λµç»°ºÅɸѡ,βºÅ·ûºÏ:AABB;ABAB;AA...

µÚÒ»²½£º·Ö±ðÌáÈ¡ºó5λÊý¾Ý 1.1¹«Ê½£º1£©ÌáÈ¡µÚ4λºÅÂ룺=MID(A3,4,1)2£© ÌáÈ¡µÚ5λºÅÂ룺=MID(A3,5...


ÔÚÏßµÈ Çë¸ßÊÖÖ¸½Ì excelÔõôɸѡ³öabcabcÀàÐ͵ĻòÕßÊÇabc...

(LEFT(A2,2)=MID(A2,3,2))*(MID(A2,3,2)=RIGHT(A2,2)) ÓÃÀ´É¸Ñ¡Á½Êý×ÖÖظ´Èý´ÎµÄ£¨ababab£©¡£


±¾ÈËÏë¶Ôexcel±í¸ñÖеĵ绰ºÅÂë½øÐÐɸѡ ÈçABAB ABCABC Çó...

Èç¹ûÏ뽫ºÅÂëÖаüº¬Ä³Ð©Êý×ÖµÄÌôÑ¡³öÀ´£¬¿ÉÒÔÓá°Êý¾Ý-ɸѡ-×Ô¶¯É¸Ñ¡¡±£¬È»ºóÓá°×Ô¶¯É¸Ñ¡¡±ÏÂÀ­°´Å¥Öеġ°×Ô¶¨Ò塱¹¦ÄÜÀ´É¸Ñ¡¡£»¹...


excelÖвéÕÒABAB¸ñʽÊý¾Ý

±ÈÈçµç»°ºÅÂëÔÚµÚÒ»ÁÐ,°ÑÕâ¸ö·ÅÔÚµÚ¶þÁÐ,ÆäËüµÄÀ­ÏÂÈ¥¾ÍÊÇÁË,Èç¹ûβÊýÊÇABABµÄ»°,ÔòÏÔʾTRUE,·ñÔòÏÔʾFALSH A8ÄãÒªÏàÓ¦Ð޸ĵÄ,...


ÔõôÓñí¸ñɸѡ³öÀ´ aabb abab abbb?

Ê×ÏÈ°ÑÏëҪɸѡ³öÀ´µÄ¹æÔò ÁгöÀ´ ±ÈÈç A1-A3 ÊäÈëaabb/abab/abbb È»ºó¸ù¾Ý²»Í¬ÐèÒª ÓÃvlookup/count...


ÇóÒ»¸öºÅÂëɸѡÈí¼þ»òÕßEXCELɸѡ·½·¨

ABAB¹«Ê½£º=IFERROR(INDEX(A:A,SMALL(IF((MID(A$2:A$1000,8,2)=RIGHT(A$2:A$1000,2))*(...


Çë½Ì¸ßÊÖ,ÈçºÎͨ¹ýExcelɸѡ³öÊÖ»úºÅÂë ¨C ÊÖ»ú°®ÎÊ

(A2,11,1)),"ABAB",IF(AND((MID(A2,10,1)-MID(A2,9,1))=1,MID(A2,11,1)-MID(A2,10,1)=1),"ABC",IF(AND(MID(A2,8,...


Ïà¹ØËÑË÷

ÈÈÃÅËÑË÷