Lists

[Hutchy]

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

 

[Bob Umlas]

Select Col A, use Data/Filter/Advanced Filter and click the Unique values
checkbox, then copy this list to column B.