TL;DR. Option1: =FILTER(FILTER(A1:G7,K1:K7=K1),{0,1,0,1,0,0,0}). Option2: - Reference =FILTER(INDEX(tblData,SEQUENCE(ROWS(tblData)),{4,3,5}) ...
確定! 回上一頁