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