SOLVED

I cannot fill series with a gap of more than 1

New Contributor
Hello sir/ma'am,
I have been trying to fill series with a gap of 3 but I am not able to. When i take 2 numbers 3 and 6, and drag the cursor upto some cells and select flash fill, it doesn't fill the other cells with a gap of 3. If I use numbers 10 and 15, it's perfectly fine. I am attaching a video with this message. Please help.
4 Replies
best response confirmed by Gryffinpuf (New Contributor)
Solution

@Gryffinpuf 

As per your video, instead of dragging just C2 (with value 3 in there) down the rows, select C2:C3 and then drag the C3 down.

i.e. Right now you are just dragging C2, now you select both the cells C2 and C3 and then drag C3 down.

@Gryffinpuf 

Just like this.

 

Thank you so much sir. Now I am able to do that.

@Gryffinpuf 

You're welcome! Glad it helped.