Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default selecting unique items

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?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default selecting unique items

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?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,646
Default selecting unique items

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:

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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default selecting unique items

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!
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default selecting unique items

On Feb 7, 12:22 pm, Stefi wrote:
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:



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 -


und herzlichen dank Stefi!!! :)


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default selecting unique items

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 -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting multiple items from drop-down list [email protected] Excel Discussion (Misc queries) 1 October 25th 07 01:24 PM
Selecting multiple items from a drop down list Jeremy Excel Discussion (Misc queries) 4 December 11th 06 03:53 PM
Selecting a subset of items from a list Steve Excel Worksheet Functions 0 July 31st 06 01:50 PM
Selecting items from a list. To transfer to another worksheet? Mountain goat Excel Discussion (Misc queries) 0 September 19th 05 06:06 PM
Selecting matching items in a column Panajohn Excel Discussion (Misc queries) 2 August 15th 05 09:52 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"