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

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