Filter Data

[Buska]

Hello All,

I got a colum A with data like above and need a formula in order t
filter it to colum B with only unique items:

A B
John John
Ann Ann
Rick Rick
John
Ann

Thanks Very Muc

 

[Ron de Bruin]

Hi Buska

You can use Advanced filter
http://www.contextures.com/xladvfilter01.html#FilterUR

Or use my Add-in that have many options
http://www.rondebruin.nl/easyfilter.htm