Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to Auto Fill the same value into 6 cells multiple times. My issue comes up during the auto fill. Rather than receiving A2(six times), A3(six times), A4(six times), A5(six times)... as a reference point, I'm getting A2 (six times), but its immediately screwing up if I try to auto fill after that.
Solved by G. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/05/2018 - 08:51
Good Afternoon. What problems are you having with AutoFill?
Excelchat Expert 29/05/2018 - 08:52
Are you trying to autofill the same things each time?
User 29/05/2018 - 08:52
The finl six in that column should output #3, but I get #1 from A13 instead.
Excelchat Expert 29/05/2018 - 08:53
So you're trying to repeat the same six items down multiple times?
User 29/05/2018 - 08:53
Excelchat Expert 29/05/2018 - 08:54
Like #1 six times, #2 six times, etc.?
User 29/05/2018 - 08:54
Yes, its more complex later on, but that is the gist.
Excelchat Expert 29/05/2018 - 08:56
Ok, autofill will not understand what you're trying to do. If you do six 1s and six 2s it will just repeat that sequence. What is the end result that you are looking for?
Excelchat Expert 29/05/2018 - 08:58
And, do you need to do this one time or do you need to repeat this task?
User 29/05/2018 - 08:58
The ability to have 100+ numbers at the top of the spreadsheet that I can allocate 6 rows to each number
User 29/05/2018 - 08:58
I need to repeat it.
User 29/05/2018 - 08:59
I know what excel is doing, but I cant figure out the correct way to manipulate the autofill...
Excelchat Expert 29/05/2018 - 09:00
Ok, I think I understand now. Hang on and let me try something in my spreadsheet and see if I can come up with a quick answer.
User 29/05/2018 - 09:00
User 29/05/2018 - 09:01
The left is my issue, the right is the correct numbers.
Excelchat Expert 29/05/2018 - 09:06
I can't see a way that autofill can handle this. It can be done programmatically using a short VBA routine. It could also be done using a formula, but that would take some real thought on how to write the formula.
User 29/05/2018 - 09:07
Yeah, I had a bad feeling about that. Ok, thank you for the help.
Excelchat Expert 29/05/2018 - 09:07
Sorry, do you have any experience with VBA?
User 29/05/2018 - 09:08
A little, but I'll figure another way to format it.
Excelchat Expert 29/05/2018 - 09:08
OK, Sorry that we couldn't use the autofill feature. Please try us again if you have another issue.
User 29/05/2018 - 09:09
No problem. Thanks anyways.
Excelchat Expert 29/05/2018 - 09:09
Your Welcome

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc