用什么公式可以把C-M列 所有逗号左边的数值的最小值填在P21单元格内， 所有逗号右...

kk8700

用什么公式可以把C-M列
所有逗号左边的数值的最小值填在P21单元格内，
所有逗号右边的数值的最小值填在Q21单元格内。

橒♂蝣

P21=SMALL(--MID(C21:M23,1,FIND(",",C21:M23)-1),1)
Q22=SMALL(--MID(C21:M23,FIND(",",C21:M23)+1,100),1)

满坛皆为吾师

三键

1. =MIN(IMREAL(SUBSTITUTE(C21:M23,",","-")&"i"))

复制代码

1. =MIN(--TEXT(1%,SUBSTITUTE(C21:M23,",",";")))

复制代码

1. =MIN(-IMAGINARY(SUBSTITUTE(C21:M23,",","-")&"i"))

复制代码

1. =MIN(--TEXT(-1%,SUBSTITUTE(C21:M23,",",";")))

复制代码

楼兰城主TT

1. =MIN(--TEXT(-1%^COLUMN(),SUBSTITUTE($C21:$M23,",",";")))

复制代码

绊成ρìи

=MIN(IMREAL(SUBSTITUTE(C21:M23&"j",",","+")))
=MIN(IMAGINARY(SUBSTITUTE(C21:M23&"j",",","+")))

quqiyuan

1. =MIN({1,0}*TEXTSPLIT(TEXTJOIN(";",1,C21:M23),",",";"))

复制代码

1. =MIN({0,1}*TEXTSPLIT(TEXTJOIN(";",1,C21:M23),",",";"))

复制代码

xfbanxian

=MIN(--LEFT($A$3:$K$5,FIND(",",$A$3:$K$5)-1))
=MiN(--MID($A$3:$K$5,FIND(",",$A$3:$K$5)+1,99))

kk8700

绊成ρìи 发表于 2023-5-21 16:05
=MIN(IMREAL(SUBSTITUTE(C21:M23&"j",",","+")))
=MIN(IMAGINARY(SUBSTITUTE(C21:M23&"j",",","+")))

大佬=MIN(IMREAL(SUBSTITUTE(C21:M23&"j",",","+")))
如果逗号左边没有负数 公式 就会变0， 是正数的情况下 能选择最小的正数吗