| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to delete alternate rows in excel
Hey, Bernard -- you should have a "MVP" logo after your name -- ask Mike F
about how this happens. And, in case I forgot, congrats! (Or am I mistaken??) "Bernard Liengme" wrote: Mike has a good solution but if VBA is not for you: Insert a new A column In A1 enter 0, in A2 enter 1 Copy A1:A2 down to end of worksheet, resulting in 0,1,0,1,0,1.... Sort all the data using A as the key Now delete either the top or the top half Then delete column A best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Martin R" <Martin wrote in message ... I have a table generated by a datalog program running for about 7 days. Unfortunately the log interval was inadvertantly set to 5 instead of 30 seconds, & the data now extends over 2 text files, each of about 65000 lines, close to the Excel 2003 limit. Can anyone advise a simple way to delete alternate rows, either in the text file or in the excel file? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting alternate blank rows in Excel | Excel Discussion (Misc queries) | |||
| How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
| Excel should let you fill alternate rows automatically | Excel Discussion (Misc queries) | |||
| Delete a group of alternate cells | New Users to Excel | |||
| How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
Threaded Mode
