Related:
- Help me write a Macro for Excel PLEASE
- How to write & in laptop - Guide
- Spell number in excel without macro - Guide
- Download macros for excel - Download - Spreadsheets
- How to write e with accent - Guide
- Excel date format dd.mm.yyyy - Guide
2 responses
You don't need a macro for this. One might be helpful, but I think the time & effort you would spend creating/finding etc. the macro would be more than doing it semi-manually.
[note: it's unclear if your "seconds" data is sequential (i.e. 1,2,3,...,6000), or randomly distributed between 1 and 6,000 (i.e. 47, 359, 2, 1000,...etc.). If it is sequential your problem is very easy. But assuming it's not... do the following...
Assuming your data are in two adjacent columns... (if they're not you could transpose/move them)...
Create an index column, 1,2,3,...,etc. Put this adjacent to your data. Make sure you put a header/label above the column of data as "index" or something.
Then, elsewhere (on the same sheet) create a criteria column, 7,14,21,28,...,etc. This column must have the exact same label as the "index" column.
Then use the Data Menu>Filter>Advanced Filter
Select the index column for your List Range, the Criteria column for your criteria, Make sure you include the column headers (i.e. the text that says "index" or whatever) for both columns, then filter the list in place.
This will give filter out the six rows between every seventh row. If your data and you index column are lined up next to each other, your data will receive the same filtering. From there, just select your data columns, and copy them into a new sheet. Then your done! Good Luck!
[note: it's unclear if your "seconds" data is sequential (i.e. 1,2,3,...,6000), or randomly distributed between 1 and 6,000 (i.e. 47, 359, 2, 1000,...etc.). If it is sequential your problem is very easy. But assuming it's not... do the following...
Assuming your data are in two adjacent columns... (if they're not you could transpose/move them)...
Create an index column, 1,2,3,...,etc. Put this adjacent to your data. Make sure you put a header/label above the column of data as "index" or something.
Then, elsewhere (on the same sheet) create a criteria column, 7,14,21,28,...,etc. This column must have the exact same label as the "index" column.
Then use the Data Menu>Filter>Advanced Filter
Select the index column for your List Range, the Criteria column for your criteria, Make sure you include the column headers (i.e. the text that says "index" or whatever) for both columns, then filter the list in place.
This will give filter out the six rows between every seventh row. If your data and you index column are lined up next to each other, your data will receive the same filtering. From there, just select your data columns, and copy them into a new sheet. Then your done! Good Luck!
