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: