B C D E F G H I
392 6,184,480,000 9,775,720,000 6,184,480,000 0 0 0 0 0
=INDEX(B392:I392,1,MIN(IF((B392:I3920)*(B392:I392"")*COLUMN(B392:I392),(B392:I3920)*(B392:I392"")*COLUMN(B392:I392),10^10)))
得出结果是:false
你这个范围从第二列开始
公式修改为
=INDEX(B392:I392,1,MIN(IF((B392:I3920)*(B392:I392"")*COLUMN(B392:I392),(B392:I3920)*(B392:I392"")*COLUMN(B392:I392),10^10))-1)