某人某日在何處 (13096)

日期：

J2=LOOKUP(1,0/(A$2:A$99=H2)/(B$2:B$99<=I2)/(C$2:C$99>=I2),D$2:D$99)

起訖日期須連接=LOOKUP(1,0/(A$2:A$99=H2)/(B$2:B$99<=I2),D$2:D$99)

起訖日期須連接=LOOKUP(1,0/(A:A=H2)/(B:B<=I2),D:D)



留言

張貼留言