Hi,

Im having trouble with duplcate entrys in a very large spreadsheet.
Some customers details are duplcated in spreadsheet, if so they are
always listed in adjacent rows directly below. Therefore I need to
search in one column and delete the entire row if the cell matches the
cell directly above it.

any help would be much appreciated,
Many thanks,
Andrew


--
Shandy720
------------------------------------------------------------------------
Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230
View this thread: http://www.excelforum.com/showthread...hreadid=565927

Hi Shandy720,

Try this it will find duplicates

Put this formula in B1

=IF(A1=A2,"duplicate","") and copied this down to the end - this says
if A1 is the same as A2 mark it as "duplicate" otherwise put "blank"

Alter cell ref to suit

oldchippy:)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=565927

If column A contains a list of names, starting at A1, you can use the
following formulae in B1 and copy to remaining column B to filter out
duplicates:

Col. A Col. B

Miller =IF(COUNTIF(A:A,A1)1,"Duplicate?","")
Smith =IF(COUNTIF(A:A,A2)1,"Duplicate?","")
Herbert =IF(COUNTIF(A:A,A3)1,"Duplicate?","")
Mayer =IF(COUNTIF(A:A,A4)1,"Duplicate?","")
Miller =IF(COUNTIF(A:A,A5)1,"Duplicate?","")
Slayman =IF(COUNTIF(A:A,A6)1,"Duplicate?","")
etc.

The result will be a "Duplicate? next to every identical Miller.





"Shandy720" wrote:


Hi,

Im having trouble with duplcate entrys in a very large spreadsheet.
Some customers details are duplcated in spreadsheet, if so they are
always listed in adjacent rows directly below. Therefore I need to
search in one column and delete the entire row if the cell matches the
cell directly above it.

any help would be much appreciated,
Many thanks,
Andrew


--
Shandy720
------------------------------------------------------------------------
Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230
View this thread: http://www.excelforum.com/showthread...hreadid=565927

Thanks a lot both of you for helping me out and so quickly!!!

old chippy - cheers really simple and works perfectly - that was
exactly what i need!

Have a good weekend!


--
Shandy720
------------------------------------------------------------------------
Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230
View this thread: http://www.excelforum.com/showthread...hreadid=565927