建ç«è¾
å©åºåï¼Jå°Såï¼J2ç¨å
¬å¼ï¼
=OR(MMULT(--ISNUMBER(FIND(MID(INDIRECT("C"&MAX(COLUMN(B1))),{1,2,3,4,5,6},1),MID(LEFT(TEXT($A2,"0.0000000000000E+0"),15)*10^13&"",ROW($1:$10),5))),{1;1;1;1;1;1})=5,(MMULT(--(LEN(SUBSTITUTE(MID(LEFT(TEXT($A2,"0.0000000000000E+0"),15)*10^13&"",ROW($1:$9),6),{1,2,3,4,5,6,7,8,9,0},""))<5),{1;1;1;1;1;1;1;1;1;1})=1)*(MMULT(--ISNUMBER(FIND(MID(INDIRECT("C"&MAX(COLUMN(B1))),{1,2,3,4,5,6},1),MID(LEFT(TEXT($A2,"0.0000000000000E+0"),15)*10^13&"",ROW($1:$9),6))),{1;1;1;1;1;1})>=5))
æ°ç»å
¬å¼ï¼æCTRL+SHIFT+å车ï¼å³æå°Såï¼ä¸æï¼
ç¶å设置æ¡ä»¶æ ¼å¼ï¼é项AåBåï¼æ¡ä»¶æ ¼å¼ï¼ç¨å
¬å¼ï¼
=OR($J1:$S1)
è®¾ç½®æ ¼å¼ï¼åä½é¢è²ä¸ºçº¢è²ã
追é®ä¸è¡å¦ãå
å¼ãè¦ä»¥Aåæåææ°çä¸ä¸ªåå
æ ¼ä¸çæ°ä¸ºæ åã