View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NAKA NAKA is offline
external usenet poster
 
Posts: 2
Default Why is my drag and fill not following the pattern?

I'm trying trying to create a column of number in a pattern:
1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this
pattern, it inserts extra rows and included decimals. How do I prevent this?