答案1
尝试,
在 中R18
,将公式复制到右边直到空白处:
=IFERROR(INDEX($R$15:$X$15,AGGREGATE(15,6,COLUMN($A$1:$G$1)/($R$16:$X$16>0),COLUMN(A1))),"")
尝试,
在 中R18
,将公式复制到右边直到空白处:
=IFERROR(INDEX($R$15:$X$15,AGGREGATE(15,6,COLUMN($A$1:$G$1)/($R$16:$X$16>0),COLUMN(A1))),"")