delete every other row

Add a new column.

In the first non-header cell in the column,enter the formula:

=ISODD(ROW())

Fill down to the end of the table.

Copy; Edit > Paste Values (to remove the formula).

Sort the table on this column.

Select the rows you want to delete (top half, labeled FALSE or bottom half, labeled TRUE).

Go Table > Delete Column to remove the selected column.

Regards,

Barry

Barry,

I would add...

Add a column and Fill with =ROW(). Select Column, Command-C, Edit > Paste Values. Do this first.

When finished with other operations, Sort on this column to restore original order in case it suffered a shuffle in the other sort. Just some insurance.

Jerr

Hi both of you

I feel dumb on this thread.

What is the link between :

How can I automatically delete every other row

and the fact that a row number is odd or is even ?

Yvan KOENIG (VALLAURIS, France) mardi 9 août 2011 15:14:37

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

Yvan,

The idiom "every other row" is interpreted as every 2nd row, which would be all the even rows or all the odd rows.

Jerry

Thanks a lot.

It's what we spell "Un rang sur deux".

Automatic translator just replaced Engish words by French ones returning :

Chaque autre rangée

or

toutes les autres lignes

which had really no link with even/odd.

It's a nice day, not only the sun shine but I learnt something new 😉

Yvan KOENIG (VALLAURIS, France) mardi 9 août 2011 16:42:55

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !