Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Extract Unique Records in Excel

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Tools for Excel Tables Start

Extract unique records  
Use this versatile tool to group records in a database, meeting the rigorousness you will usually need for a given operation.
So, how rigorous can the search for unique records be?
As rigorous as you wish.
You may want get all records that differ from one another only as to the first field, or you may want to get records that differ as to the three first fields of the database, or you may just want to get all non-repeated records.
This resourceful tool does it for you. Let's see a simple example.
Consider the database shown below. Notice that repeated rows have non-white background colors.



First of all, assume the first row contains the database field names. This is a basic requirement to use this suitable tool.
Follow these steps:
Select any cell belonging to the database you are to work with or select the target range, and click on the Unique Rows buttons in the toolbar.
1. Choose the name of the field you need to filter (to search for repeated records only in this field) or choose the option. All Fields (to carry out a full search)



You will see that if you choose a field name, you may search in other field by clicking on this button (button icon here) as a new control in which you may choose another field to filter will be added.



2. choose the place you want the operation to take place in: either on the same database or in a new sheet. In this example, choose to paste in a new sheet.


Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us