Excel 2007 - Remove duplicate values when importing data from ODBC 1

[jeffm777]

I want to create a drop down list from a named range. This named range will be a list of inventory locations from an ODBC query into my inventory. Problem is, I need this list to only show unique values. Also, I have the ODBC query set to automatically refresh upon opening the spreadsheet so I need it to query the data and return the unique list of locations automatically.

Can this be done?

 

[Andrzejek]

What is your query?

Have fun.

---- Andy

 

[jeffm777]

SELECT Inventory.Location
FROM SQLUser.Inventory Inventory

 

[SkipVought]

hi,

I do this quite often. You have several options.

1) do a separate query on a separate sheet, like

select distinct [inventory location]
from [your table(s)]
where [i]whatever criteria are necessary[/i]

2) do a separate query to the Excel Sheet where the first query resides, like

select distinct [inventory location]
from [SheetName$]

3) you could use the Advanced Filter feature to make a UNIQUE list of that column.

4) you could use the PivotTable feature to make a UNIQUE list of that column.



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

I would try:

SELECT [blue]Distinct[/blue] Inventory.Location
FROM SQLUser.Inventory Inventory [blue]
ORDER BY ...[/blue]

and see what happens

Have fun.

---- Andy

 

[jeffm777]

Thanks. Worked like a charm!

 

[Andrzejek]

Half of this star goes to Skip

Have fun.

---- Andy