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