Thread: How to grab data from non-consective cells into consecutive cells in a different work

Greetings,

I've a spreadsheet with multiple worksheets.

I'm looking to display a sequence of data in worksheet 1, based on data present in worksheet 2. Say for example my data is as follows:

Worksheet 2:

Cell A1=6
Cell A6=7
Cell A11=8

Worksheet 1:
A B
1 2001
2 2002
3 2003

Is there a way that I can insert to display in consecutive cells in worksheet 1, data from equal intervals (but not from consecutive cells) from worksheet 2?

E.g. take value from every 5th row of column A in worksheet 2, and display it in rows 2, 3, 4 etc.....in worksheet 1?


I've attached a sample of what I mean and how I wish for it to be displayed as the end result.

Any help much appreciated.

On sheet 1, in a cell on row 1 use the formula:

=OFFSET(Sheet2!$A$1,(ROW()-1)*5,0)

And copy down.

Does that only work if there are no filled cells in between the values shown in worksheet 2?

No, it just picks every 5th row.

Thanks.

Oddly enough this works perfectly in a basic spreadsheet but when I apply it to the complex spreadsheet I'm working on it starts spewing out "#value".

That formula is sensitive to which row it's on, so you might need to tweak it a little to get it to work on a sheet in a different format.