View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Incremental Numbering

"fastcar" wrote:
I would like to be able to enter a number is Excel worksheet say G7 and
have that number incremented by 1 every 9 rows.
eg.
G7......2378
G16....2379
G25....2380 [corrected]
and so on.


With the 2 initial inputs in
G7......2378
G16....2379


think we could just select G7:G24, then fill* down as far as desired
*drag the fill handle at the bottom right corner of G24
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---