Next, put the XLOOKUP formula inside a TRANSPOSE formula. Dynamic Sizes Arrays. it can only be applied on a range of cells. (F7) Close VBE (Alt + Q or press the ...
確定! 回上一頁