Duplicate
 

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

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

I highlighted this, but before finishing the page we had a powercut and
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?

Cheers


--
philiphales
------------------------------------------------------------------------
philiphales's Profile: http://www.excelforum.com/member.php...o&userid=18641
View this thread: http://www.excelforum.com/showthread...hreadid=465837

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

--
Ian
--
"philiphales"
wrote in message
...

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

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

I highlighted this, but before finishing the page we had a powercut and
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?

Cheers


--
philiphales
------------------------------------------------------------------------
philiphales's Profile:
http://www.excelforum.com/member.php...o&userid=18641
View this thread: http://www.excelforum.com/showthread...hreadid=465837

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



--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=465837

You could insert an adjacent column and use a formula like:

=countif(a:a,a1)
and drag down

Then apply data|filter|autofilter to that column.
Filter to show values 1.

Chip Pearson has lots of ways to work with duplicates/uniques at:
http://www.cpearson.com/excel/duplicat.htm

philiphales wrote:

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

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

I highlighted this, but before finishing the page we had a powercut and
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?

Cheers

--
philiphales
------------------------------------------------------------------------
philiphales's Profile: http://www.excelforum.com/member.php...o&userid=18641
View this thread: http://www.excelforum.com/showthread...hreadid=465837

--

Dave Peterson