If I have a column of names (BUT the names are repeated) in a listed and I
want to have a formula that pulls out each name 1 time and puts it in a list
on a different sheet how do I do this.

Example WorkSheet 1
ABC Company
ABC Company
DEF Company
ETC. down the list.

I want to end up with 1 name on 1 line for each company on another worksheet.

Example Worksheet 2
ABC COmpany
DEF Company
ETC