every 15th row - formula

[Reniek]

Hi,

Could you please tell me how can I find every 15th row in one column of data
using excel formula?
Many thanks for an answer.


Irek
(e-mail address removed)

 

[Frank Kabel]

Hi
dio you want to sum the row cvalues?. If yes try:
=SUMPRODUCT(--(MOD(ROW(A1:A1000)-1,15)=0),A1:A1000)

 

[Bob Phillips]

Irek,

Put this formula in A1 and copy down.

=INDEX(A1:A1000,ROW(A1)*15)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Sorry, I meant in B1 and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Reniek]

Thank you, could you advise one more thing?

I'd like to copy down formula and have in column B "found" exactly 15th row
after previous one, I mean B15, B30, B45,etc...

I know it is easy but I can't

Reniek

 

[Alan Perkins]

Hi Reniek,

Try = IF(MOD(ROW(),15)=0,"Found","")

HTH

Alan P

 

[Reniek]

Thanks a lot !!!

Hi Reniek,

Try = IF(MOD(ROW(),15)=0,"Found","")

HTH

Alan P