select unique to make list

S

Spunky

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
 
A

Alan Beban

Spunky said:
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
Click to expand...
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Mail Merge Directory Conditional Page Break 0
Excel --> Word 4
How to make repeating drop-down lists? 2
Copy previous record into form field 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Drop down list control value in vba 2
Autonumber field in Excel that behaves the same as Access 0

Top