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.
....
One more option. With a random integer from 1 to 49 in A1, use the
following formula in A2.
=MOD(A1,49)+1
Bookmarks