Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

I have a data series which consists of daily data in one worksheet in Excel 2010.

I also have an array (because of some matrix multiplication) in it, and I cannot create a table with an array in it, so I can't really use vlookup (or can I? Someone please enlighten me).

I need to retrieve data every 7 days for some testing from this particular column in the first sheet.

How do I use vlookup (or something similar) to get the data every 7 days into another worksheet beside it? I have the dates as the first column.

share|improve this question
What have you tried? Filters? Query? Pivot table? – CharlieRB Sep 10 '12 at 13:41
not familiar with any of them. which is the easiest/fastest/best way to do this? – daysandtimes Sep 11 '12 at 2:37
1  
This site is really designed to help with specific problems. Although you ask a good question, it is difficult to answer because it seems you lack basic knowledge of how Excel works. You might want to start here...Basic tasks in Excel 2010. Edit your question with more detail of how the data is placed in the worksheet will help us understand what you are trying to do. – CharlieRB Sep 11 '12 at 12:43
Also, your question is limited to how to use VLOOKUP. Are you open to other solutions how to retrieve your weekly data? If so, please state that in your question. – CharlieRB Sep 11 '12 at 12:46
it's not limited! i'm open to any solution – daysandtimes Sep 13 '12 at 7:42

1 Answer

up vote 0 down vote

A quite simple way, though not elegant, would be to copy entire sheet to a new sheet. Add a column and put 1 in that column alongside the first row with data. Drag that cell’s bottom right corner down six rows with Ctrl depressed (ie until a 7 appears). Then select the 1:7 block and drag its bottom RH corner, down with Ctrl depressed, to the last data row. Select entire worksheet (click top left corner, above ‘1’ and to the left of `A’. then Data and Filter. Click the down arrow in the top row of the added column and uncheck the day sequence you wish to retain (say every ‘6’, click on 6). Select all the rows numbered in blue and Delete Row. Re click Filter.

share|improve this answer
thanks this seems basic enough – daysandtimes Sep 13 '12 at 7:43
@daysandtimes Since you know how to apply a green tick (ie your accept rate is 50%) I'm guessing the above is sarcastic, so you don't have an acceptable answer. If so, some further clarification might get you one! – pnuts Sep 26 '12 at 14:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.