Duplicate

P

philiphales

I was sent a large spreadsheet full of data and needed to check th
validity of the info in a column.

I found that an item had been input in error - instead of the actua
figure the preceeding figure had been duplicated.

I highlighted this, but before finishing the page we had a powercut an
I lost the error.

I do not really want to check the whole thing again - it took 3 hours.

Is there any way of finding duplicate, but unknown data?

Like find all references of duplicate entries?

Cheer
 
I

Ian

If the dulpicate cells are adjacent in the same column, try this macro. It
records all duplicate rows in another column. The comments should explain
it.

Sub find_dupes()
rr = 1 ' row to start recording results
rc=2 ' column to record results
c = 1 ' column to search (1=A, 2=B...)
For r = 2 To 12 ' rows to search (must start at minimum of 2)
If Cells(r, c) = Cells(r - 1, c) Then
Cells(rr, rc) = r
rr = rr + 1
End If
Next
End Sub
 
D

dominicb

Good morning Philiphales

I have a free add-in available to anyone who requests it, which
contains a number of utilities. One of these will do just what you're
asking. If you want this, just drop me a line.

HTH

DominicB
[email protected]
 
Top