| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to consoidate a list of multiples to a list of singles
I have a column that looks like this;
Direct Mail-Ltr Direct Mail-Ltr Direct Mail-Ltr Direct Mail-PC Radio Radio Magazine Magazine Magazine Newspaper I would like to create a list from this column that looks like this; Direct Mail-Ltr Direct Mail-PC Radio Magazine Newspaper I've racked my brain on this to no avail. Any help would be of great use. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to consoidate a list of multiples to a list of singles
Use DataAdvanced Filter. Tick Unique values option.
HTH -- AP "Mr. Yanni" a écrit dans le message de news: ... I have a column that looks like this; Direct Mail-Ltr Direct Mail-Ltr Direct Mail-Ltr Direct Mail-PC Radio Radio Magazine Magazine Magazine Newspaper I would like to create a list from this column that looks like this; Direct Mail-Ltr Direct Mail-PC Radio Magazine Newspaper I've racked my brain on this to no avail. Any help would be of great use. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| Check 2 different list get associated value from a column | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Linear Mode
