Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Weeding
I have a large data file (58000 odd lines worth) and need to weed it down to
half the size. Is there any quick way of deleting all odd or all even lines from the spreadsheet as I need an overall representation of the data, not just the first or second half of it. Thankyou |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Weeding
Hi
One way Create a helper column with the formula =MOD(ROW(),2) Copy down the range of your data by double clicking the fill handle at the bottom right of the cell. Then apply a filter DataFilterAutofilter and on the new helper column select either 1 or 0. If you do want to delete this data, then mark the range of visible data by selecting the row numbers, right click and select delete. -- Regards Roger Govier "Maow" wrote in message ... I have a large data file (58000 odd lines worth) and need to weed it down to half the size. Is there any quick way of deleting all odd or all even lines from the spreadsheet as I need an overall representation of the data, not just the first or second half of it. Thankyou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |