autopopulate sl.no.based on a cell value

I have cell value in work sheet based on a function and it changes
accordingly.Based on this cell value I want to populate a serial numbers in a
column.suppose c1=15,Iwant to populate from d10:d100 serial number as
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 upto d24 only rest should appear as
blank.Iwant this funtion as array that means d10:d100= formula.maximum cell
value is around 90.Any idea to get this result.

In D10 enter:
=IF(ROWS($1:1)<=$C$1,ROWS($1:1),"")
and copy down to D100

Hope this helps
Rowan

TUNGANA KURMA RAJU wrote:
> I have cell value in work sheet based on a function and it changes
> accordingly.Based on this cell value I want to populate a serial numbers in a
> column.suppose c1=15,Iwant to populate from d10:d100 serial number as
> 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 upto d24 only rest should appear as
> blank.Iwant this funtion as array that means d10:d100= formula.maximum cell
> value is around 90.Any idea to get this result.

Many thanks for helping

"Rowan Drummond" wrote:

> In D10 enter:
> =IF(ROWS($1:1)<=$C$1,ROWS($1:1),"")
> and copy down to D100
>
> Hope this helps
> Rowan
>
> TUNGANA KURMA RAJU wrote:
> > I have cell value in work sheet based on a function and it changes
> > accordingly.Based on this cell value I want to populate a serial numbers in a
> > column.suppose c1=15,Iwant to populate from d10:d100 serial number as
> > 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 upto d24 only rest should appear as
> > blank.Iwant this funtion as array that means d10:d100= formula.maximum cell
> > value is around 90.Any idea to get this result.
>

You're welcome.

TUNGANA KURMA RAJU wrote:
> Many thanks for helping
>
> "Rowan Drummond" wrote:
>
>