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.
|