Dynamic list of distinct values

Deverti

Board Regular
Joined
Sep 5, 2020
Messages
58
Office Version
  1. 365
Platform
  1. Windows
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?
 
Last edited:

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,932
copy the data to the new sheet,
run REMOVE DUPLICATES.
your list is ready.
 

Deverti

Board Regular
Joined
Sep 5, 2020
Messages
58
Office Version
  1. 365
Platform
  1. Windows
well i mean, thanks for the input but that s hardly even related to my question
 

Watch MrExcel Video

Forum statistics

Threads
1,119,195
Messages
5,576,606
Members
412,738
Latest member
PHILLY0041
Top