Dynamic list of distinct values

[Deverti]

i need a list of distinct values from my "table_1[col_x]" to be displayed in another "table_2[col_y]".
additionally, "table_2" consists of several columns and i need the list of distinct values in "table_2[col_y]" to be connected to the source data and fully integrated, so not just some array 'spill' list but something which can be sorted along with other data in "table_2" and updates if changes have been made to the source

is this even possible in excel?

 

[ranman256]

copy the data to the new sheet,
run REMOVE DUPLICATES.
your list is ready.

 

[Deverti]

well i mean, thanks for the input but that s hardly even related to my question