Thread: Why is my drag and fill not following the pattern?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Why is my drag and fill not following the pattern?
=INT((ROWS($1:1)-1)/3)+1

copy down as far as needed



"NAKA" wrote:

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?
Reply With QuoteReply With Quote