Deleting double rows
 

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

--
I don''t Excel at Excel

Deleting double rows
 

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:

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

--
I don''t Excel at Excel

Deleting double rows
 

Thanks very much Stefi - works well!!

Cheers,

Nic
--
I don''''t Excel at Excel


"Stefi" wrote:

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:

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

--
I don''t Excel at Excel

Deleting double rows
 

You are welcome! Thanks for the feedback!
Stefi

€žNic Zun€� ezt Ã*rta:

Thanks very much Stefi - works well!!

Cheers,

Nic
--
I don''''t Excel at Excel


"Stefi" wrote:

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:

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

--
I don''t Excel at Excel