| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a list from multiple (sometimes the same) codes
I have in column A a list of say 100 codes of which many may be duplicated.
I wish to produce in column B an automatic list (produced without further manual input) using all the different codes in column A i.e. Answers in column A may be XX12, XX13, XX13, YY45, YY45, YY45, ZZ33 & R45 In column B I want to see a list of items (don't know how they will be sorted) showing XX12, XX13, YY45, ZZ33 & R45 thus avoiding duplications. Therefore I don't want to produce a drop down list which requires manual choices in column B. How do I do this please? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a list of info in A1 cell in multiple worksheets | Excel Discussion (Misc queries) | |||
| Creating a document to assist with municipal codes | Setting up and Configuration of Excel | |||
| Creating hyperlinks to a word file with field codes | Excel Discussion (Misc queries) | |||
| Creating UPC Codes... | Excel Discussion (Misc queries) | |||
| Creating drop down list for multiple cell ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
