+ Reply to Thread
Results 1 to 12 of 12

Create a list from a column and eliminate duplicates

  1. 02-22-2010, 07:47 PM #1
    Jogier505
    Jogier505 is offline
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Create a list from a column and eliminate duplicates

    I have a list of names "H3:H66". I want to create a list starting with "L3" from column H that eliminates any duplicate name from the first list.

    JIm O
    Last edited by Jogier505; 02-23-2010 at 09:01 PM.
    Reply With QuoteRegister To Reply
  2. 02-22-2010, 08:14 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Create a list from a column and eliminate duplicates

    1) Highlight the cells H2:H66 (be sure to highlight H2 as well to get the "title" of the column)
    2) Click on Data > Filter > Advanced Filter > Copy > [x] Unique Values Only to copy to L3.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 02-22-2010, 08:19 PM #3
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Create a list from a column and eliminate duplicates

    Jogier505,

    Detach/open workbook "Create a list from a column and eliminate duplicates - Unique Sorted List - Jogier505 - SDG10.xls".

    You would copy the formula in cell L3 down till it displays a blank cell.
    Attached Files Attached Files
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
  4. 02-22-2010, 08:44 PM #4
    Jogier505
    Jogier505 is offline
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Re: Create a list from a column and eliminate duplicates

    JBeaucaire,

    I was trying to have a user friendly formula that would add a new name to the list in column L as a new name is added in column H.




    stanleydgromjr,

    I am unable to open the worksheet.




    Jim O
    Reply With QuoteRegister To Reply
  5. 02-23-2010, 02:36 PM #5
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Create a list from a column and eliminate duplicates

    Jogier505,

    Please attach your workbook/worksheet - click on "New Post", then scroll down and see "Manage Attachments".
    Reply With QuoteRegister To Reply
  6. 02-23-2010, 03:45 PM #6
    Jogier505
    Jogier505 is offline
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Re: Create a list from a column and eliminate duplicates

    Here is a sample sheet.

    JIm O
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-23-2010, 04:17 PM #7
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Create a list from a column and eliminate duplicates

    Jogier505,

    See the attached workbook "List - Jogier505 - SDG10.xls".
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 02-23-2010, 09:00 PM #8
    Jogier505
    Jogier505 is offline
    Forum Contributor
    Join Date
    09-09-2009
    Location
    Columbus. Ohio
    MS-Off Ver
    Excel 2000
    Posts
    199

    Re: Create a list from a column and eliminate duplicates

    stan,


    Wow that is quite the formula, it works perfectly. I was expecting something short and simple, thank you very much for your time.

    Jim O
    Reply With QuoteRegister To Reply
  9. 08-04-2010, 10:06 AM #9
    gerotimm
    gerotimm is offline
    Registered User
    Join Date
    08-02-2010
    Location
    santiago
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Create a list from a column and eliminate duplicates

    sample sheet provided by jogler505 does NOT quite work...
    try adding e.g. zero, or kkk etc etc
    Reply With QuoteRegister To Reply
  10. 08-04-2010, 10:20 AM #10
    Lee-Anne
    Lee-Anne is offline
    Registered User
    Join Date
    08-04-2010
    Location
    Cairns, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Create a list from a column and eliminate duplicates

    Quote Originally Posted by JBeaucaire View Post
    1) Highlight the cells H2:H66 (be sure to highlight H2 as well to get the "title" of the column)
    2) Click on Data > Filter > Advanced Filter > Copy > [x] Unique Values Only to copy to L3.
    Ok I am brand new here but I have to say - this is my favorite new place - I so want to learn how to really get around excel and make the most of it and this is my first new trick in my book of how to make my excel life EASY - thanks - off to find some more and maybe even ask a question or two
    Reply With QuoteRegister To Reply
  11. 08-04-2010, 10:39 AM #11
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Create a list from a column and eliminate duplicates

    Lee-Anne,

    Training / Books / Sites:

    How to Learn to Write Macros
    http://articles.excelyogi.com/playin...ba/2008/10/27/

    How to use the macro recorder
    http://articles.excelyogi.com/

    Click here and scroll down to Getting Started with VBA.
    http://www.datapigtechnologies.com/ExcelMain.htm

    If you are serious about learning VBA try
    http://www.add-ins.com/vbhelp.htm

    Excel Tutorials and Tips - VBA - macros - training
    http://www.mrexcel.com/articles.shtml

    See David McRitchie's site if you just started with VBA
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    Debra Dalgleish has some notes how to implement macros here:
    http://www.contextures.com/xlvba01.html

    David McRitchie has an intro to macros:
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    Ron de Bruin's intro to macros:
    http://www.rondebruin.nl/code.htm

    Creating custom functions
    http://office.microsoft.com/en-us/ex...117011033.aspx

    Writing Your First VBA Function in Excel
    http://www.exceltip.com/st/Writing_Y...Excel/631.html

    http://www.excel-vba.com/
    http://www.mvps.org/dmcritchie/excel/getstarted.htm
    http://www.exceltip.com/excel_links.html

    (livelessons video)
    Excel VBA and Macros with MrExcel
    ISBN: 0-7897-3938-0
    http://www.amazon.com/Excel-Macros-M...7936479&sr=1-1

    http://www.xl-central.com/index.html

    http://www.datapigtechnologies.com/ExcelMain.htm

    Dependent validation lists. Debra has a neat little tutorial here.
    http://www.contextures.com/xlDataVal02.html

    Cascading queries
    http://www.tushar-mehta.com/excel/ne...ing_dropdowns/

    http://www.contextures.com/xlDataVal05.html

    Excel Data Validation - Add New Items
    http://www.contextures.com/excel-dat...ation-add.html

    Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
    This page describes how to write code that modifies or reads other VBA code.
    http://www.cpearson.com/Excel/vbe.aspx

    Locating files containing VBA
    Searching Files in Subfolders for VBA code string:
    http://www.dailydoseofexcel.com/arch...a-code-string/

    http://www.pcreview.co.uk/forums/thread-978054.php

    Excel 2003 Power Programming with VBA, by John Walkenbach

    VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad

    Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley

    VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad

    Excel 2007 Book: you can try this...there is a try before you buy ebook available at this link…
    http://www.mrexcel.com/learnexcel2.shtml

    DonkeyOte: My Recommended Reading:

    Volatility
    http://www.decisionmodels.com/calcsecretsi.htm

    Sumproduct
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    Arrays
    http://www.xtremevbtalk.com/showthread.php?t=296012

    Pivot Intro
    http://peltiertech.com/Excel/Pivots/pivotstart.htm

    Email from XL - VBA
    http://www.rondebruin.nl/sendmail.htm

    Outlook VBA
    http://www.outlookcode.com/article.aspx?ID=40

    Function Dictionary
    http://www.xlfdic.com/

    Function Translations
    http://www.piuha.fi/excel-function-name-translation/

    Dynamic Named Ranges
    http://www.contextures.com/xlNames01.html

    And, as your skills increase, try answering posts on sites like:
    http://www.mrexcel.com/
    http://www.excelforum.com/
    http://www.ozgrid.com/
    http://www.vbaexpress.com/portal.php
    http://p2p.wrox.com/excel-vba-79/


    Where to paste code in VBE VBA
    Introducing the Excel VBA Editor
    http://www.ask.com/web?qsrc=2417&o=1...cel+VBA+Editor

    VBA for Excel (Macros)
    http://www.excel-vba.com/excel-vba-contents.htm

    VBA Lesson 11: VBA Code General Tips and General Vocabulary
    http://www.excel-vba.com/vba-code-2-1-tips.htm

    Excel VBA -- Adding Code to a Workbook
    http://www.contextures.com/xlvba01.html
    Reply With QuoteRegister To Reply
  12. 08-05-2010, 02:25 AM #12
    Lee-Anne
    Lee-Anne is offline
    Registered User
    Join Date
    08-04-2010
    Location
    Cairns, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Smile Re: Create a list from a column and eliminate duplicates

    Wow Stan - many thanks - that is a lot of reading.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1