Every 20th line

[Brian]

Is there a way to mark every 20th (or 5th or 9th -
whatever) line? For auditing purposes, we want to be sure
that whatever lines we select are random and figured that
by writing some sort of formula to have it mark each 20th
line with an "x", then we wouldn't have to do it manually.

Any thoughts?

 

[JE McGimpsey]

one way:

=IF(MOD(ROW(),20)=0,"X","")

 

[Ron de Bruin]

Try this formula in the first row and copy down

=IF(MOD(ROW(A1),5),"","X")

I use 5 in the example

 

[Brian]

Thanks to both of you. These both work as I wanted them
to.

Brian