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

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

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

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

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

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

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