Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lists
If I have a list of say, 100 values (Cells A1-A100), and there many
duplicates, is there a way to create a "master" list elsewhere that does NOT contain the duplicates. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lists
Hi,
You can solve this problem by using Advanced Filter option in Excel. For example A (Column) Name a c a e a d a e Just click on the label (in the above example it is Name (Cell A1), And then click Data-- Advanced Filter -- And then click the check box, Unique records only check box. And also give the cell address in which you want to display the unique records (Copy to option in dialog box, example B1). Then you will get the following output A B name name a a c c a e e d a d a e Hope this will clear your doubt. Regards, Soundar "PAL" wrote: If I have a list of say, 100 values (Cells A1-A100), and there many duplicates, is there a way to create a "master" list elsewhere that does NOT contain the duplicates. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lists
An alternative would be to run the list through a pivot table - the output
would be unique. You could then copy and paste special it to any place you want. "Soundar" wrote: Hi, You can solve this problem by using Advanced Filter option in Excel. For example A (Column) Name a c a e a d a e Just click on the label (in the above example it is Name (Cell A1), And then click Data-- Advanced Filter -- And then click the check box, Unique records only check box. And also give the cell address in which you want to display the unique records (Copy to option in dialog box, example B1). Then you will get the following output A B name name a a c c a e e d a d a e Hope this will clear your doubt. Regards, Soundar "PAL" wrote: If I have a list of say, 100 values (Cells A1-A100), and there many duplicates, is there a way to create a "master" list elsewhere that does NOT contain the duplicates. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
lists from other lists in excel | Excel Worksheet Functions |