对散料那单元格使用条件属性
LEFT(RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1),FIND("R",RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1))-1)>10
两个条件用or连接
FIND("R",RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1)) = 0
OR(LEFT(RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1),FIND("R",RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1))-1)>10,REPLACE(RIGHT(a1,INARRAY(" ",REVERSEARRAY(SPLIT(A1,"")))-1),'R','') = 0)
用or()
上面公式没改,下面那个加个replace。可以试试
试试过滤条件
再用OR连接一下
LEFT(RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1),FIND("R",RIGHT($$$,INARRAY(" ",REVERSEARRAY(SPLIT($$$,"")))-1))-1)=0