依當時自動改變 C3:AG38=(TEXT(TODAY(),"M月D日")=LOOKUP("座",$A$3:$A3)&C$2)*(MOD(ROW(A1)-1,3)+1=LOOKUP(1,0/(MOD(NOW(),1)>(ROW($1:$3)-1)/3),ROW($1:$3)))
依J41 M41改變=(TEXT($J$41,"M月D日")=LOOKUP("座",$A$3:$A3)&C$2)*(MOD(ROW(A1)-1,3)+1=LOOKUP(1,0/($M$41>(ROW($1:$3)-1)/3),ROW($1:$3)))
留言
張貼留言