if嵌套多且返回结果不一致,总体是错误,请问高手们如何解决?

2024-11-20 01:26:58
推荐回答(1个)
回答1:

=INDEX({"约标","约完","标书审批中","标书完成","开标中","定标中","定标","合同审批"}, MIN(IF(I2:P2<>"",COLUMN(I2:P2),"")))
数组公式,按Ctrl+Shift+Enter结束