+ Reply to Thread
Results 1 to 3 of 3

Formula for removind duplicates without using 'remove duplicates' button

  1. #1
    Registered User
    Join Date
    03-20-2011
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    11

    Smile Formula for removind duplicates without using 'remove duplicates' button

    Hi there1

    is there a formula that allows me to automatically remove duplicate values in a column in excel?

    Let's say i have column A which contains a list of web addresses. I need a formula that will enable me to display in column B all the unique web addresses and leave out the duplicates. i cannot use the "remove duplicates' function in excel for this as the data in column A will be changing from time to time.

    I really hope someone can help me with this! Many thanks in advance!

    best regards,
    Aaron
    Last edited by acaran02; 03-20-2011 at 10:48 AM.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Formula for removind duplicates without using 'remove duplicates' button

    Hello, yes, it is possible to create a unique list of values with formulas. It will involve helper columns and the formulae used are not trivial. Post a workbook that shows your data structure, so the formulae can be written to reflect your needs.

    cheers,

  3. #3
    Registered User
    Join Date
    03-20-2011
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Formula for removind duplicates without using 'remove duplicates' button

    HI Teylyn,

    Thanks for your help. I have created a new thread that is similar to what i am trying to do here. Please see it here: http://www.excelforum.com/excel-gene...ml#post2492793

    I have seen your previous advises and I can tell you know a lot about excel. Maybe you can help me out with this one too. Many thanks Teylyn!

    Best,
    A

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1