Results 1 to 8 of 8

Advanced filter to get unique values

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Timisoara, Romania
    MS-Off Ver
    Excel 2003
    Posts
    2

    Advanced filter to get unique values

    Hi all,
    Referring to the attachment below, I am trying to get the unique numbers in the B column. Most of the numbers in that B column appear more than once, and I would like to get a different column to display only the unique records. So wanted to use the Excel built-in method of filtering (Data->Filter->Advanced Filter) and (after having selected all the numbers in the B column, excluding the "Internal_PN" column header), I have used the options "Copy to another location" and "Unique records only" in order to obtain (on column E) the needed result.
    header.JPG
    It works fine except for the first value in the column. I get the 101026 number twice. All other numbers in the original column appear just once on column E, except for this very first number which insists on appearing twice. I am using excel 2003, but I noticed the same in excel2007, so it must be something I am doing wrong.

    Any help will be greatly appreciated.

    Best Regards,
    Cristian
    Attached Files Attached Files
    Last edited by brumbarchris; 01-13-2012 at 08:14 AM. Reason: solution found

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