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?
3 Replies
- If you only need a list of those item and no other columns besides it, try Pivot. It would not be heavy on the sheet as well
- Hi
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.
