 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Filtering 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... 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  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > 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... 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 SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > Hi captculver > [quoted text clipped - 10 lines] >> The uniqueness of each record is defined by 5 fields. Is there a way to >> filter for unique records given these conditions?? Thanks... 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 <captcul...@discussions.microsoft.com> 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...
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.