Create List of UNIQUE Values-CodePudding

Right now I have the following happening:

EAN | Material | Title | Size | Weight

Though depending on the category, one might be added or deleted.

I want to create a seperate list which lists all unique values ever found and saves old ones, which are not in the cell anymore.

Right now I have =UNIQUE(transpose(E1:L1))

This allows me to create a list of all the unique values, though if one gets removed, it doesn't stay.

Here is an example file:

Please let me know if you have any issues with this, or would like me to explain anything.

CodePudding user response：

function unique() {
  Logger.log([...new Set(SpreadsheetApp.getActiveSheet().getRange("E1:L1").getValues().flat())]);
}