I am adding a formula to a worksheet via VBA which should be:=UNIQUE(IF(TableA[ColumnA]=A1,TableA[ColumnB],"")) This utilises the new SPILL feature in Excel ...
確定! 回上一頁