Does it have to be a formula?

If no, then...

Debra Dalgleish explains it he
http://www.contextures.com/xladvfilter01.html#FilterUR

Kim Shelton at PDC wrote:

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

--

Dave Peterson