+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Advanced Filtering

  1. #1
    Registered User
    Join Date
    12-21-2008
    Location
    Rochester
    Posts
    2

    Advanced Filtering

    I have a list of 665 elements and I need to make a list with only unique elements.I have tried 'Advance Filtering-Unique values only' function, but somehow the resulting list still contain duplicate elements. Attached is the list. Column 1 is raw list and column 2 is the list obtained by using the function. I have tried doing it in Excel2003 and Excel2007 but its still not working. Any help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Where did the letters come from?
    Although they appear to be the same, if you counted the number of characters in the same cells they will have a different count.
    Sort column A then use the formula in column b
    =len(a1)
    double click on the fill handle(little black corner on the bottom left of the cell) to copy the formula all the way down.
    The count is different you will notice.
    in Column C use the formula
    =trim(a1)
    and copy all the way down.
    then column D use
    =len(c1)
    copy the formula down and the duplicate cells should have the same number count now

  3. #3
    Registered User
    Join Date
    12-21-2008
    Location
    Rochester
    Posts
    2
    Thanks for the help. These letters are actually symbols for companies included in S&P500, Nasdaq100, and DowJones65.I am trying to get a consolidated list with unique companies in all these three indices.

  4. #4
    Registered User
    Join Date
    12-20-2008
    Location
    US
    MS-Off Ver
    Excel 2007, Student Version
    Posts
    33
    Excel 2007
    Use TRIM()
    then Data Tools > Remove Duplicates
    http://www.mediafire.com/file/hzn3y2zmhyw/Try.xlsx

+ 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