Need help with duplcates please!!

[Shandy720]

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

 

[oldchippy]

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

 

[fak119]

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]

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

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

Have a good weekend