Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting multiple items from drop-down list | Excel Discussion (Misc queries) | |||
Selecting multiple items from a drop down list | Excel Discussion (Misc queries) | |||
Selecting a subset of items from a list | Excel Worksheet Functions | |||
Selecting items from a list. To transfer to another worksheet? | Excel Discussion (Misc queries) | |||
Selecting matching items in a column | Excel Discussion (Misc queries) |