MARK EVERY FOURTH ROW

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


HI ALL,

In column A, I have consecutive numbers 1 thru 7,000

In column B, I would like to write a formula and copy it down to show
a number 1 on every fourth line .

How can I accomplish this?


Thanks for your help.

Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
x-- Access to over 1.6 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

.

Relevant Pages

  • Pictures etc
    ... K3PID ... x-- 3,500+ Binary NewsGroups, and over 100,000 other groups ... x-- UNLIMITED DOWNLOAD ... Prev by Date: ...
    (sci.electronics)
  • Re: CALENDAR
    ... >Cell Value Is equal to =TODAY ... x-- 3,500+ Binary NewsGroups, and over 100,000 other groups ... x-- UNLIMITED DOWNLOAD ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • teeside
    ... anyone what to have fun with a gril 17 ... x-- 3,500+ Binary NewsGroups, and over 100,000 other groups ... x-- UNLIMITED DOWNLOAD ... Prev by Date: ...
    (uk.local.teesside)
  • Re: MARK EVERY FOURTH ROW
    ... starting with the first cell... ... > Tom Snyder ... > x-- UNLIMITED DOWNLOAD ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • CALENDAR
    ... I set up a vertical calendar where column A contains dates expressed ... x-- 3,500+ Binary NewsGroups, and over 100,000 other groups ... x-- UNLIMITED DOWNLOAD ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)