I’ve succeeded in extracting the unique cells in a column, but the result is static. To accomplish that, I selected a range of cells, then Data > More Filters > Standard Filter…, set the criteria to be Not Empty, set other criteria for other columns, set checkmarks in No duplications, and in Copy results to, lastly clicked Ok.
The cells are filled with static content. I’d like this to be dynamic. The list would be in it’s own sheet, so I’m not concerned with overwriting any cells should the list lenghten.