98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Duplicates records
Duplicates records
Resolved · Low Priority · Version Standard
Miya has attended:
Excel Intermediate course
Duplicates records
If you have a long list of figures/codes, how do you find an unintentional duplicate? If you don't know what you're searching for, how do you find a duplicate?
RE: Duplicates records
for this instance, we'll say that your list is in column A
in cell B1, type =countif(A1,A:A)
This will give the amount of times the data in cell A1 occurs in column A. If it's unique, cell B1 will show 1
drag this formula down and you will be able to see where the duplicates are quite easily.
Even better, you can do a conditional format after that to say if any cell in column B is greater than 1. (Colour the cell red for example)
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Add Text to Displayed Numbers in Excel 2010To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text! |