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?
Can this be done?