| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I return the unique entries from a column to a listbox
I have a colum with 30 odd thousand rows.
There are only 6 or so unique item-codes in it (eg BLD, COW, MCU...) I want to use a list box to give an option for a user to select from. I have set up a dynamic range (because the number of rows will change each month) and I have listed this as the souce for the listbox datainput. Unfortunately it returns all of the items in the range, not just the unique items. Is there a named range fromula I can use or is it a VBA issue? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) | |||
| How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
| Finding Unique Values in Column | Excel Discussion (Misc queries) | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| How do I count or display unique data in a column? | Excel Worksheet Functions | |||
Threaded Mode
