LinkBack URL
About LinkBacks
Hi,
I have a workbook with 2 sheets.
On the first sheet there is 1 column with 3000 rows.
On the second sheet, I want to display in a column, the data in row 4 (of the first sheet), the second cell the data in row 34 etc
Can anybody help me out?
Hi,
I have a workbook with 2 sheets.
On the first sheet there is 1 column with 3000 rows.
On the second sheet, I want to display in a column, the data in row 4 (of the first sheet), the second cell the data in row 34 etc
Can anybody help me out?
Assuming the data is on Sheet1.
Formula:
=INDEX(Sheet1!$A$1:$A$3000,(ROW()-1)*30+4)
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks