Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter away rows of data
I have a huge amount of data and I only want to use every tenth row of data.
How do I do to filter out the data? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter away rows of data
Assume source data in Sheet1's cols A to C from row1 down
In another sheet, place in say, A1: =OFFSET(Sheet1!$A$1,ROWS($1:1)*10-10,COLUMNS($A:A)-1) Copy A1 across to C1, fill down as far as required This extracts every 10th row in Sheet1 starting from row1, viz: A1:C1, then A11:C11, then A21:C21 and so on Adapt the "10" to suit -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "PGA" wrote: I have a huge amount of data and I only want to use every tenth row of data. How do I do to filter out the data? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter away rows of data
Use a helper cell to number the rows 1-10 repeatedly, and then filter on
the desired number. PGA wrote: I have a huge amount of data and I only want to use every tenth row of data. How do I do to filter out the data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell Data Filter Fails to Integrate New Data-rows | Excel Discussion (Misc queries) | |||
How do I sort or filter rows without column A data changing? | Excel Discussion (Misc queries) | |||
Why don't all my data rows show up in auto-filter? | Excel Worksheet Functions | |||
Copy to in Adv filter deletes data in lower rows | Excel Discussion (Misc queries) | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions |