| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down Delete Multiples
I have created a dropdown in excel 2007. This drop down contains a list of
data with many repeats, ie A A A B B C D D How can I have a list only show a data point ONCE so it would look like... A B C D This is important as I created drop downs dependant on other drop downs -- cleaning up these lists will improve the usability of the workbook. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop-down Delete Multiples
Use datafilteradvanced filter to get a unique listname it use the name
=mylist -- Don Guillett Microsoft MVP Excel SalesAid Software "shepster" wrote in message ... I have created a dropdown in excel 2007. This drop down contains a list of data with many repeats, ie A A A B B C D D How can I have a list only show a data point ONCE so it would look like... A B C D This is important as I created drop downs dependant on other drop downs -- cleaning up these lists will improve the usability of the workbook. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Multiples from a drop down list | Excel Worksheet Functions | |||
| Delete a drop down box | Excel Discussion (Misc queries) | |||
| How do i delete drop box | Excel Discussion (Misc queries) | |||
| delete used records from drop down list? | Excel Worksheet Functions | |||
| How to add and delete items from a list box or drop down box? | Excel Discussion (Misc queries) | |||
Linear Mode
