Help with Excel

Need to clean up a spreadsheet

[JVB_Mktg]

Hope this is the right place to ask...

Is there any way to delete a row if the value of a field is the same as the value of the field in the row above.

i.e.

c1 - car
c2 - car
c3 - car
c4 - car
c5 - car
c6 - truck
c7 - truck
c8 - bike

I would want to delete c2,c3,c4,c5 and c7 The result would be:

c1 - car
c2 - truck
c3 - bike

TIA,
Javi

<edit>spelling</edit>

[Mardi_Gras]

Select your data - it works best if you've applied column labels.

Select Data>Filter>Advanced Filter

Be sure to check "unique Records only."

You can either use the "filter in place" option, or select another location to have your de-duped data sent to.

<<added>>This will eliminate all duplicates, but if you only desire to eliminate cases where two consecutive items are duplicates (but non-consecutive duplicates are okay) I would use conditional formatting to find the dupes. There are some programs to do that and auto-delete, but no free ones that I know of.<</added>>

[JVB_Mktg]

Thanks Mardi! That was easy :)