筛选时间段区间内的所有数据

天涯论剑

要求：
根据SHHET2表的C列下单时间判断是否在SHEET 1表A列的所有时间段之间出现，是的话返回整行所有数据

良良

？
A2=IFERROR(INDEX(Sheet2!A:A,SMALL(IF(TRANSPOSE(MMULT(COLUMN($A:$Z)^0,ISNUMBER(VDB(,,-IMAGINARY(SUBSTITUTE(Sheet1!$A$2:$A$27,"--","-")&"i")%%,IMREAL(SUBSTITUTE(Sheet1!$A$2:$A$27,"--","-")&"i")%%,TRANSPOSE(Sheet2!$C$2:$C$59)%%))*1)),ROW($2:$59)),ROW(A1))),"")
三键，右拉、下拉。

Meteor-渣渣

Meteor-渣渣

sheet1的A4单元格的起始日期，2014应该是写错了

象山海鲜

1. =FILTER(Sheet2!A2:G59,ISERROR(0/(LOOKUP(C2:C59,--MID(Sheet1!A2:A29,{1,19},16))<C2:C59)))

复制代码

我要成为专家

1. =INDEX(Sheet2!$A:$G,SMALL(IF(ISNUMBER(VDB(,,--RIGHT($A$2:$A$27,16),--LEFT($A$2:$A$27,16),TRANSPOSE(Sheet2!$C$2:$C$59))),TRANSPOSE(ROW($2:$59))),ROW(A1)),COLUMN(A1))

复制代码

三键