求助按实际完成日期为条件定位显示单元格数值

明日之星

求助按实际完成日期显示上面对应字段名称.zip (11.54 KB, 下载次数: 2)

2018-7-6 09:21 上传

点击文件名下载附件

cabcyvr

R7=INDEX($4:$4,IFERROR(MAX(IF($S$4:INDIRECT(SUBSTITUTE(ADDRESS(4,MAX(IF(($S$5:$BD$5&$S$6:$BD$6="实际完成")*(S7:BD7<>""),COLUMN(S7:BD7))),2),"$4",)&4)<>"",COLUMN($S$4:INDIRECT(SUBSTITUTE(ADDRESS(4,MAX(IF(($S$5:$BD$5&$S$6:$BD$6="实际完成")*(S7:BD7<>""),COLUMN(S7:BD7))),2),"$4",)&4)))),MAX(IF(S3:INDIRECT(SUBSTITUTE(ADDRESS(4,MAX(IF(S7:BD7<>"",COLUMN(S7:BD7))),2),"$4",)&4)<>"",COLUMN(S3:INDIRECT(SUBSTITUTE(ADDRESS(4,MAX(IF(S7:BD7<>"",COLUMN(S7:BD7))),2),"$4",)&4))))))         数组执行后下拉复制