Excel AutoFil

[nai0248]

I have a list of numbers in a specific order in column C. The sequences is not important, I just want to determine the minimum and maximum values for row count of 10, 13 or some smaller number. Then in column F place the counting sequence of steps.



so if the numbers in column c are;
1,2,3,4,5,6,7,8,9,13,10,11,12 or 1,2,3,4,5,6,7,8,9,10 or 7,7,8,9,10
then f column would be;
1,2,3,4,5,6,7,8,9,10,11,12,13 or 1,2,3,4,5,6,7,8,9,10 or 1,2,3,4,5

The only way I can think of is a macro but don't know enough about macro's.

[macropod]

Hi nai,

Assuming you numbers start in row 1 and continue down in consecutive cells, all you need is =ROW() in the adjacent column. If the numbers start in a row other than 1, use a forumla like =ROW()-X, where X is the number of rows preceding thr starting row.

[ConneXionLost]

If you place the desired row number in cell E2, then these formulas will provide you with the MAX and MIN of column C:

=MAX(INDEX($C$1:INDEX($C$1:$C$10,E2),,1))

and,

=MIN(INDEX($C$1:INDEX($C$1:$C$10,E2),,1))

Cheers,