Use Microsoft Excel 2007 Formulas to Highlight Duplicate Rows
If you are in the process of collating large chunks of data, chances are that there can be duplicate entries too in your spreadsheet. If you are planning to manually do a check to identify and remove the entries, you are in for a great loss – loss of productivity, time and efforts. The easier way out would be to apply the specific formula that can help you to complete the task in a jiffy. If you have just started your journey with this application and are looking for simple Microsoft Excel 2007 formulas to speed up your work, here is one handy formula mentioned below for you.
The easy step solution to highlight duplicate rows in your spreadsheet is as:
1. To find duplicate rows, first collate the data from columns into a new column.
2. Select a cell in a new column and type ‘=reference to the first cell of the row you want to collate & ‘any attribute you want to add’ & reference to the last cell of the row you want to collate’.
3. Press ‘Enter’ on your keyboard and click on the bottom right corner of the cell and drag it all the way down to the last cell.
4. Select the cell where you want to display the result.
5. Type ‘=COUNTIF (the absolute reference to the first cell shown by the $ sign : reference to the first cell, reference to the first cell again)’.
6. Press ‘Enter’ on your keyboard and click on the bottom right corner of the cell and drag it all the way down to the last cell.
Isn’t this simple? Now, keep the formula handy to be able to apply it again when you are doing a similar task. And, if you are interested in enjoying a short solution video, here is one that can teach you the same steps mentioned above, in a visual manner.
To watch the video, click on the video window below: