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