请高手帮忙；判断“F”例数大小(个数)谢谢！

909459520

请高手帮忙；判断“F”例数大小(个数)谢谢！

我走我流

=COUNT(0/(MMULT(-(0&TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F7:F99,"(",),")",),"-",),",",REPT(" ",99)),{1,2}*99-98,99))),{1;-1})<0))

咔咔乱坠

辅助列解法

1. =IFNA(LOOKUP(9^9,ABS(-MID(F7,ROW($1:$3),1)))>LOOKUP(9^9,ABS(-MID(F7,ROW($4:$6),1))),"")

复制代码

人间油物

左边大：

1. =SUM(IFERROR(N(-SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F7:F38,",","/"),"-",),"(","(0 ")>1),))

复制代码

右边大：

1. =SUM(IFERROR(N(-SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F7:F38,",","/"),"-",),"(","(0 ")<1),))

复制代码

就是大于1跟小于1的区别，自己改符号即可

咔咔乱坠

借人间油物老师的思路，写一个无需辅助列的

1. =SUM(N(EVALUATE(IFERROR(SUBSTITUTE(SUBSTITUTE(RIGHT(LEFT(F7:F38,LEN(F7:F38)-1),LEN(F7:F38)-2),"-",),",",">"),))))

复制代码

一剑惊心

=COUNT(0^MMULT(IFERROR(-MID(SUBSTITUTE(SUBSTITUTE(D7:D43,"-",),",",")         ("),{1,9},9),),{1;-1}))
红字里两个参数换个位置就能分别求出左右要求

静听溪流

左大：
=SUM(N(MMULT(IFERROR(ABS(TEXT({1,-1}%,SUBSTITUTE(SUBSTITUTE(MID(F7:F27,2,9),")",""),",",";"))),),{1;-1})>0))

静听溪流

右大：
=SUM(N(MMULT(IFERROR(ABS(TEXT({1,-1}%,SUBSTITUTE(SUBSTITUTE(MID(F7:F27,2,9),")",""),",",";"))),),{1;-1})<0))

橒♂蝣

=LET(x,ABS(--FILTER(MID(F7:F39,2,FIND(",",F7:F39)-2),ISNUMBER(--MID(F7:F39,2,FIND(",",F7:F39)-2)))),
yy,MID(F7:F39,FIND(",",F7:F39)+1,FIND(")",F7:F39)-FIND(",",F7:F39)-1),
y,ABS(--FILTER(yy,ISNUMBER(--yy))),
a,SUMPRODUCT(1*(x-y>0)),
b,SUMPRODUCT(1*(y-x>0)),
CHOOSE({1;2},a,b))

rym9401

一剑惊心 发表于 2023-6-11 09:33
=COUNT(0^MMULT(IFERROR(-MID(SUBSTITUTE(SUBSTITUTE(D7:D43,"-",),",",")         ("),{1,9},9),),{1;-1}) ...

老师，您好。这个公式在我这得不到结果，后经排查，发现有两个问题。1.MID前要加一个TRIM。2.您用的空格，TRIM删除不了，后面改用英文状态下的空格，可以删除。