请教大佬，求绝对值的最小值

要D4输入公式，下拉

C列先abs一下呗

加了辅助列

=MIN(ABS(IF(A$74:A$92=A74,B$74:B$92,9^9)))

=MIN(ABS(FILTER($B$1:$B$15,$A$1:$A$15=$A1)))

=MIN(ABS(INDIRECT("B"&MATCH(A4,$A$4:$A$22,0)+3&":"&"B"&MATCH(A4,$A$4:$A$22,0)+2+COUNTIF($A$4:$A$22,A4))))
数组{}

=min(abs(if($A$4:$A$22=A4,$B$4:$B$22,9^9)))

=minif(abs(b$4:b$23),a4=a$4:a$23)

miniifs

下载贴吧APP
看高清直播、视频！

分享到: