Every 20th line

  • Thread starter Thread starter Brian
  • Start date Start date
B

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?
 
Try this formula in the first row and copy down

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

I use 5 in the example
 
Back
Top