On Mon, 18 Jul 2005 11:19:08 -0700, Nelson wrote:
I have 6 columns across going 40 rows down. I'm entering random numbers in
row 1 across columns A to F. The numbers have to stay in a range from 1 to
49 but are totally random in row 1. From rows 2 through 40 I want the
numbers to automatically fill down consecutively but not to exceed 49. When
a certain column hits 49 I want that column to start over at 1 again.

Put this in A2, drag across through F2, and then drag down as far as
you need:

=IF(A1=49,1,A1+1)

This will check to see if the previous number was 49, if this is true,
it will put "1", otherwise, it will add 1 to the previous number.

MP-

--
"Learning is a behavior that results from consequences."
B.F. Skinner