View Single Post
  #1   Report Post  
TUNGANA KURMA RAJU
 
Posts: n/a
Default 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.