Select every other Row to copy/cut????

  • Thread starter Too much data - Too little time
  • Start date
T

Too much data - Too little time

How do I select every other row on a large Excel Document?
 
B

Barb Reinhardt

I do this with a helper column. In the helper column, I enter

=mod(row(),2)

The result is wither 0 or 1. Autofilter the data and delete either 0 or 1
(whatever you want). Keep in mind that when you delete the data, it will
recalculate. Remove the autofilter and the helper column and VIOLA (I know
I spelled it wrong), you're done.

"Too much data - Too little time" <Too much data - Too little
[email protected]> wrote in message
news:[email protected]...
 
F

FinRazel

Or Better yet...
1. If you don't already have one, create a numbered column by creating an
empty column (A), type "1" in A1, highlight the column,
Fill->Series->Increment

2. Next to column A, create a new column (B) and enter this formula:
=IF(ISODD(A1),TRUE,FALSE).

3. Highlight your entire worksheet, and sort by column B. This will group
all even columns together, and likewise for all odd columns. Then, select
the group you want.
 
A

Alan Beban

Too said:
How do I select every other row on a large Excel Document?
Click to expand...

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, you might
want to consider the ArrayAlternates function. it will return each odd
row [ArrayAlternates(MyArray)], each even
row[ArrayAlternates(MyArray,False)], each odd
column[ArrayAlternates(MyArray,,False)], or each even
column[ArrayAlternates(MyArray,False,False)].

Alan Beban
 
Top