Referencing every 5th cell in another sheet

J

Jan.Thorstensen

I have one sheet (Sheet1) that contains data. Everey 5th row
in this sheet I want to put a referce to in sheet2.

E.g.

Sheet2.A1 = Sheet1! A1
Sheet2!A2 = Sheet1! A6
Sheet2!A3 = Sheet1! A11
Sheet2!A4 = Sheet1! A16

and so on...

Is there a way I can use Autofill in Sheet2 and return every 5th cell
from the other sheet, sheet1?

Regards
Jan
 
X

xlbo

No easy way unfortunately but this formula should do the trick:

=INDIRECT("Sheet1!A"&(ROW()*5)-4)
 
M

MartinW

Hi Jan,

One way, post this in Sheet2 cell A1
=INDEX(Sheet1!A:A,ROW()*5-4)
Grab the fill handle and drag down as far as is needed

HTH
Martin
 
J

Jan T.

No easy way unfortunately but this formula should do the trick:

=INDIRECT("Sheet1!A"&(ROW()*5)-4)
--
Rgds, Geoff








- Vis sitert tekst -

Sweet! Very Nice.

Thanks a lot!

Regards
Jan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top