Forum Discussion
Create a new table with unique records from database query table
Given: Excel 2016 I have a database query that loads a table on my worksheet and it gets updated frequently. How can I create a table next to it that lists the unique names in the database table?...
Hi
Either create a new query based on the database query or use SORT(UNIQUE(Name)).
Either create a new query based on the database query or use SORT(UNIQUE(Name)).
- I'm in Excel 2016, I don't think UNIQUE is available in this version.
