Macro help

[Mystery911]

Hi there experts!!

I have a document that has 14,000 rows all the odd rows are doubles of the even rows:

Got any ideas how to delete the odd rows so all the doubles are gone? In one shot? I am trying to make a macro but haven't figured out the code with out me putting in all the row numbers. There are no identifiers either.

Any help would be great!

:D

[qball]

ok,

first, it sounds like you have a spreadsheet as documents use lines. second, a macro can accomplish this, but is more trouble than worth, unless you'll be doing this over and over again...

Anyway, iffin excel spreadsheet, then all you need to do is select range (plus one row on top for label) and perform a Data, Filter, Advanced Filter, click unique records only. You may choose to filter in place or copy results to new location.

[Mystery911]

Thanks for the reply, I'll try that.

[qball]

you are welcome.