| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists
I have one list in column A containing data that is duplicated in different
rows at times and would like to create a second list in column B that does not include the duplicates found in the first list. I would like the entries in the column B list to contain no blank cells if possible. Thanks -- H |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
Select Col A, use Data/Filter/Advanced Filter and click the Unique values
checkbox, then copy this list to column B. "Hutchy" wrote in message ... I have one list in column A containing data that is duplicated in different rows at times and would like to create a second list in column B that does not include the duplicates found in the first list. I would like the entries in the column B list to contain no blank cells if possible. Thanks -- H |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| lists from other lists in excel | Excel Worksheet Functions | |||
Linear Mode
