Referencing every 5th cell in another sheet

  • Thread starter Thread starter Jan.Thorstensen
  • Start date Start date
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
 
No easy way unfortunately but this formula should do the trick:

=INDIRECT("Sheet1!A"&(ROW()*5)-4)
 
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
 
No easy way unfortunately but this formula should do the trick:

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








- Vis sitert tekst -
Click to expand...

Sweet! Very Nice.

Thanks a lot!

Regards
Jan.
 
Back
Top