each 15th row

[Reniek]

Hi,
In column A i have a data. I would like to copy down (B1:B60) formula and
find every 15th row previous one, I mean B15, B30, B45,etc...and then just
filter each.

Thanks
Reniek

 

[Frank Kabel]

Hi
as stated in your other post: Not really sure what you're trying to do

 

[Dick Kusleika]

Reniek

=MOD(ROW(),15)

Then filter to show zeros

 

[Dsuperc]

try this
Enter the following formula in Sheet2, beginning with cell A1 and
copying down & across:

=INDIRECT("Sheet1!A"&ROW(Sheet1!A1)+(15*(ROW()-1)))
=INDIRECT("A"&ROW(A1)+(15*(ROW()-1)))
Remember to change the Column from A to whatever, when you copy to
another column.