Deleting double rows

N

Nic Zun

I have a spreadsheet with which I wish to split in two (or delete alternate
rows). Imagine banded rows with every second shaded row to be moved into
another worksheet with the unbanded or unshaded rows remaining.

Any suggestions on how to do this?

Thanks in advance.
Nic
 
S

Stefi

In Excel2003:
Enter this formula in row 1 in an empty helper column and fill it down as
required:
=MOD(ROW(),2)=0
Apply Autofilter to the helper column and select TRUE as filtering criterium.
Select visible rows and Copy
Paste in a new sheet
Go back to the original sheet
select FALSE as filtering criterium
Select visible rows and Delete rows

Regards,
Stefi


„Nic Zun†ezt írta:
 
Top