MARK EVERY FOURTH ROW

From: lehigh46 <lehigh46@xxxxxxxxxxx>
Date: Fri, 03 Jun 2005 08:49:38 -0400

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

.

Follow-Ups:
- Re: MARK EVERY FOURTH ROW
  - From: Don Guillett
- Re: MARK EVERY FOURTH ROW
  - From: Domenic
- Re: MARK EVERY FOURTH ROW
  - From: N Harkawat

Prev by Date: Re: Pivot Tables
Next by Date: Re: Pivot Tables
Previous by thread: Conditional formatting in relation to other cells
Next by thread: Re: MARK EVERY FOURTH ROW
Index(es):
- Date
- Thread

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)