If you use VBA (and this is the programming subforum) you can place the result whereever you want.

As Jaslake pointed out: in Excel filtering assumes a columnheader: so the first item in a column will always be copied to another location. Below the copied columnheader the unique items appear.

To filter column B in sheet1 for unique items to sheet2 column K:

Sub snb()
  sheets("sheet1").columns(2).advancedfilter xlfiltercopy,,sheets("sheet2").cells(1,11),True
end sub