returning every nth row in a column

[HammerTime]

Hi all,

If I have a column full of data is there a way to copy every nth row to a new column?

For example, I may have dates and corresponding days of the week. Can I copy the date of each tuesday (i.e. every 7th row) to a new column?

Thanks

[JBeaucaire]

Well, for dates, you wouldn't actually do that, would you? You would enter the first Tuesday's date, then use a formula like =A3+7 to get the date that is 7 days later.

Anyway. If you want to get the values in cells A3,A10,A17,A24,A31 to appear in a column starting at say D1,D2,D3,D4, you could use something like this:

=INDIRECT("A"&ROW()*7-4)

The -4 is to give you the first correct value, then that should translate for all the rest. Make sure the cells are formatted the way you want since INDIRECT doesn't evaluate cells automatically the way other formulas often do in Excel.

[HammerTime]

Thanks, that is great! I didn't realise it was so easy

And yes, you are right, dates is a bad example

[maszyna]

Apologies. Deleted

[oeldere]

@maszyna

Your breaking the forum rules, interruption in another one's question.

http://www.excelforum.com/forum-rule...rum-rules.html

Please start your own question.

It also will help if you add an excel example instead of a .png