Results 1 to 3 of 3

Thread: Filter out records in a list based on a unique records only filter for one column

  1. #1

    Filter out records in a list based on a unique records only filter for one column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I've got a list of records. One of the columns is called "Item number". I want item numbers to be unique in my list of records. So I want to do a kind of unique record filter on my "Item number" column but I need to other columns to remain in sync (so the correct item name etc is still associated with an item number). Some records are true duplicates and for some an additional column is different as well (as in the example below). I know how to filter the "item number" column to have unique records but I can not do that for the whole list ...

    An example can be found below:

    Click image for larger version. 

Name:	example list.jpg 
Views:	19 
Size:	112.1 KB 
ID:	471

    Is it possible to filter the way I want to? If so, how?

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi there,

    Sorry for the late reply here. Can you upload a sample workbook with some mock data in it, rather than a picture? That will let us see what you're really after and test.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Hi there,

    One way to do this would be to utilize a helper column with a formula in it. Your formula would concatenate clues from all of the columns in which would act as your primary key (not sure how familiar you are with Access, but it is just like that). So if your columns were (not sure what your columns are exactly)...

    =A2&B2

    Would give you a value of what is in A2 and append what is in B2, in other words kind of like a poor man's Access table key. Then you can filter on that column for your uniques. The only question you would need to answer is what columns make up a completely unique (primary key).

    HTH

    Zack

    Sent from my mobile using Tapatalk
    Regards,
    Zack Barresse

Posting Permissions

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