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

Catpriest

New member
Joined
May 6, 2011
Messages
3
Reaction score
0
Points
0
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:

example list.jpg

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

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
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.
 

Zack Barresse

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
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
 
Top