You're welcome - thanks for feeding back.

Pete

On Feb 7, 11:26*am, Mortir wrote:
On Feb 7, 12:14*pm, Pete_UK wrote:





You need to have a header above your column for the following method
to work, so if you don't have one then insert a new row 1 and enter
"Countries" in A1.

Highlight all your data (plus heading) in column 1, then click on Data
| Filter | Advanced Filter - in the pop-up you should select Unique
Records Only as well as Copy to Another Location and in the Copy To
box put C1 (or some other reference if you have data in column C
already).

Then click OK and you will have your unique list in column C.

Hope this helps.

Pete

On Feb 7, 11:02*am, Mortir wrote:

i have the following case:

in one column I have some items that repeat themselves, now id like to
extract in another column only uniqu items. example

Column A
austria
belgium
latvia
latvia
greece
greece

what id like to get is
austria
belgium
latvia
greece

No repetitions. Is there a way i can do this?- Hide quoted text -

- Show quoted text -

wonderfull. thanks Pete!- Hide quoted text -

- Show quoted text -