Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting every other row to delete or move
I have an imported file that has 12 columns of data in every other row. On
the alternate rows are descriptions that I need to move out of the way of the 12 columns. I need to sum the colums, but the description gets in the way. See below: I also import a file that has garbage data on every other row, I would like to be able to select every other row for a range of rows. Any suggestions greatly appreciated. A B C D E 4233 Pay 100 200 300 400 500 4235 Health ins 50 60 70 80 90 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting every other row to delete or move
You could use a helper column and enter
=Mod(Row()) and copy down. This will give you alternating 1's and 0's. If you just want to hide the garbage, use the autofilter on this column to filter out the data you don't want and use the Subtotal function to sum up the visible cells. Or filter out the data you want to keep and delete the garbage, then turn off autofilter, leaving the data you want to keep. "Jeanne" wrote: I have an imported file that has 12 columns of data in every other row. On the alternate rows are descriptions that I need to move out of the way of the 12 columns. I need to sum the colums, but the description gets in the way. See below: I also import a file that has garbage data on every other row, I would like to be able to select every other row for a range of rows. Any suggestions greatly appreciated. A B C D E 4233 Pay 100 200 300 400 500 4235 Health ins 50 60 70 80 90 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Have VBA delete a group of cells, move information over, then add | Excel Discussion (Misc queries) | |||
Can you delete all hidden columns in an area in one move? | Excel Discussion (Misc queries) | |||
Selecting an Excel tab, Delete Worksheet command is not active | New Users to Excel | |||
can't insert, delete or move pictures | Excel Discussion (Misc queries) |