Filtering for Unique Records

[captculver]

I'm working with a dataset of approx 2K records; each record has 15 fields.
The uniqueness of each record is defined by 5 fields. Is there a way to
filter for unique records given these conditions?? Thanks...

 

[Ron de Bruin]

Hi captculver

Maybe you can create a new column that make one string of the 5 fields and filter
for unique fields with Advanced filter

Like this

=A1&B1&C1&D1&E1

And copy down

 

[Pete_UK]

Copy those 5 columns into a new sheet, columns A to E, and ensure that
you have a header row. Highlight the header and all the data, then
click on Data | Filter | Advanced Filter. In the pop-up you should
check Unique Records only, as well as Copy to Another Location -
specify G1 as the destination. Click OK and you will have your unique
records in columns G to K - you can delete columns A to F.

Hope this helps.

Pete

 

[Ron de Bruin]

I forgot to ad

If you only want to have unique records then only Advanced filter will work
With the helper column you can use AutoFilter maybe for other things

See this page for a Advanced example
http://www.contextures.com/xladvfilter01.html#FilterUR

Good luck