Filtering for Unique Records
 

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...

Filtering for Unique Records
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"captculver" wrote in message ...
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...

Filtering for Unique Records
 

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

On Mar 31, 3:43*pm, captculver
wrote:
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...

Filtering for Unique Records
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"captculver" wrote in message ...
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...