Forum home » Delegate support and help forum » Microsoft Excel Training and help » Duplicates records

Duplicates records

ResolvedVersion Standard

Tue 18 Mar 2008, 16:34 Delegate Miya said...

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?

Tue 25 Mar 2008, 12:21 Delegate Paul said...

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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Duplicates records

Duplicates records

RE: Duplicates records

Excel articles

Excel tip:

Sorting List Subtotals