selecting unique items

[Mortir]

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?

 

[Pete_UK]

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

 

[Stefi]

Select A1
Data->Advanced filter
Check Option button "Copy to another place"
Check Check box "Unique data only"
Enter $B$1 to field "Copy to"
Press OK

Regards,
Stefi


„Mortir†ezt írta:

 

[Mortir]

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







- Show quoted text -

wonderfull. thanks Pete!

 

[Mortir]

Select A1
Data->Advanced filter
Check Option button "Copy to another place"
Check Check box "Unique data only"
Enter $B$1 to field "Copy to"
Press OK

Regards,
Stefi

"Mortir" ezt írta:








- Show quoted text -

und herzlichen dank Stefi!!!

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

wonderfull. thanks Pete!- Hide quoted text -

- Show quoted text -