Home |
Search |
Today's Posts |
#1
|
|||
|
|||
select unique to make list
I have a database with a "container" field with many records with the same
container name. I want to create another sheet with a container list only listing each container one time. Example field contents below. Container CLHU4114528 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 MLCU4132098 MLCU4132098 |
#2
|
|||
|
|||
Hi
have a look at 'Data - filter - Advanced Filter' and check 'Unique records' -- Regards Frank Kabel Frankfurt, Germany "Spunky" schrieb im Newsbeitrag ... I have a database with a "container" field with many records with the same container name. I want to create another sheet with a container list only listing each container one time. Example field contents below. Container CLHU4114528 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 MLCU4132098 MLCU4132098 |
#3
|
|||
|
|||
Spunky wrote:
I have a database with a "container" field with many records with the same container name. I want to create another sheet with a container list only listing each container one time. Example field contents below. Container CLHU4114528 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 INBU4866780 MLCU4132098 MLCU4132098 If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook, then e.g., array entered into Cells A1:A14 on Sheet2 =ArrayUniques(Sheet1!A1:A14) Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
Select a name from a list of employees using Excel | Excel Discussion (Misc queries) | |||
Make Data validation List Alphabetical?? | Excel Worksheet Functions | |||
make list of information from different cells | Excel Worksheet Functions |