Create a new table with unique records from database query table

%3CLINGO-SUB%20id%3D%22lingo-sub-2893422%22%20slang%3D%22en-US%22%3ECreate%20a%20new%20table%20with%20unique%20records%20from%20database%20query%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2893422%22%20slang%3D%22en-US%22%3E%3CP%3EGiven%3A%20Excel%202016%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20database%20query%20that%20loads%20a%20table%20on%20my%20worksheet%20and%20it%20gets%20updated%20frequently.%20How%20can%20I%20create%20a%20table%20next%20to%20it%20that%20lists%20the%20unique%20names%20in%20the%20database%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rodsan724_1-1635381339012.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320672iC0F3BB2351AC56DF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rodsan724_1-1635381339012.png%22%20alt%3D%22rodsan724_1-1635381339012.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2893422%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2893911%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20new%20table%20with%20unique%20records%20from%20database%20query%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2893911%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3EEither%20create%20a%20new%20query%20based%20on%20the%20database%20query%20or%20use%20SORT(UNIQUE(Name)).%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Contributor

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?

 

rodsan724_1-1635381339012.png

 

3 Replies
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.
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