every 15th row - formula
 

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

every 15th row - formula
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Reniek" schrieb im Newsbeitrag
...
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

every 15th row - formula
 

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)


"Reniek" wrote in message
...
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

every 15th row - formula
 

Sorry, I meant in B1 and copy down

--

HTH

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


"Bob Phillips" wrote in message
...
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)


"Reniek" wrote in message
...
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

every 15th row - formula
 

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

U¿ytkownik "Bob Phillips" napisa³ w
wiadomo¶ci ...
Sorry, I meant in B1 and copy down

--

HTH

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


"Bob Phillips" wrote in message
...
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)


"Reniek" wrote in message
...
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

every 15th row - formula
 

Hi Reniek,

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

HTH

Alan P

"Reniek" wrote in message
...
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

U¿ytkownik "Bob Phillips" napisa³ w
wiadomo¶ci ...
Sorry, I meant in B1 and copy down

--

HTH

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


"Bob Phillips" wrote in message
...
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)


"Reniek" wrote in message
...
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

every 15th row - formula
 

Thanks a lot !!!
U¿ytkownik "Alan Perkins" napisa³ w wiadomo¶ci
...
Hi Reniek,

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

HTH

Alan P

"Reniek" wrote in message
...
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

U¿ytkownik "Bob Phillips" napisa³ w
wiadomo¶ci ...
Sorry, I meant in B1 and copy down

--

HTH

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


"Bob Phillips" wrote in message
...
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)


"Reniek" wrote in message
...
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