I have a master list called StockCode on a tab called InvMaster. On a separate tab, I want to recreate the list in column B such that it will exclude any value found in columns A, C, or D.
I tried this formula, testing it only with column A, but it returned #VALUE!:
=FILTER(InvMaster[StockCode], (InvMaster[StockCode]<>A:A))
The only way I can get it to do anything is to replace A:A with a single cell (i.e., A12). How do I get it to filter out values from these three other ranges? Is =FILTER the best function to use? Thanks in advance for the help!
I tried this formula, testing it only with column A, but it returned #VALUE!:
=FILTER(InvMaster[StockCode], (InvMaster[StockCode]<>A:A))
The only way I can get it to do anything is to replace A:A with a single cell (i.e., A12). How do I get it to filter out values from these three other ranges? Is =FILTER the best function to use? Thanks in advance for the help!