Excel - COLUMN Function Problem - Expert Solution

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

Adding a column exactly like tab ZC-Zorba highlighted yellow with Twitch Irony 5322 to tabs . . . ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
Solved by F. F. in 52 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 02/10/2018 - 07:07
Hello
User 02/10/2018 - 07:07
Adding a column exactly like tab ZC-Zorba highlighted yellow with Twitch Irony 5322 to tabs . . . ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
User 02/10/2018 - 07:07
I'll send the file
Excelchat Expert 02/10/2018 - 07:07
Welcome to excelchat, I see your question is about adding a column to many sheets.
Excelchat Expert 02/10/2018 - 07:07
I can help you with the problem. I'll also provide a full explanation of the solution.
Excelchat Expert 02/10/2018 - 07:07
Thank you.
User 02/10/2018 - 07:07
[Uploaded an Excel file]
User 02/10/2018 - 07:08
so when you open it please go to ZC-Zorba tab, it's 3 quarters to the right
Excelchat Expert 02/10/2018 - 07:09
Okay, I'm there.
User 02/10/2018 - 07:09
ok
User 02/10/2018 - 07:09
so if you see highlighted yellow Twitch Irony 5322 in column AL
User 02/10/2018 - 07:09
AL/AM
Excelchat Expert 02/10/2018 - 07:09
Hmm, I can see that.
User 02/10/2018 - 07:10
I want to put those in all the tabs exactly like this without messing up any other formulas in tabs ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
User 02/10/2018 - 07:10
just adding twitch irony 5322 to ZD-Zorba, etc
Excelchat Expert 02/10/2018 - 07:12
You mean you want to insert new columns to these tabs? Just like the AL/AM column of ZC-Zobra tab?
User 02/10/2018 - 07:13
yes and put the formulas in just like AL6 and AM6
Excelchat Expert 02/10/2018 - 07:13
Got it.
Excelchat Expert 02/10/2018 - 07:13
Please give me a few minutes.
User 02/10/2018 - 07:13
no problem
User 02/10/2018 - 07:14
just please send when you are done
Excelchat Expert 02/10/2018 - 07:14
Sure, please stay with me.
Excelchat Expert 02/10/2018 - 07:23
[Uploaded an Excel file]
Excelchat Expert 02/10/2018 - 07:23
Please download and check the file.
User 02/10/2018 - 07:25
one moment
Excelchat Expert 02/10/2018 - 07:25
Sure, take your time.
User 02/10/2018 - 07:26
ok so sorry
User 02/10/2018 - 07:27
so AL6 from ZD-Zorba
User 02/10/2018 - 07:27
should be Jan-ZD
User 02/10/2018 - 07:27
I can change it, not a big deal
Excelchat Expert 02/10/2018 - 07:27
Okay.
User 02/10/2018 - 07:28
does that make sense?
Excelchat Expert 02/10/2018 - 07:28
I'm sorry not really. I have just copied the formula as instructed from the ZD-Zorba tab and pasted on other tab.
Excelchat Expert 02/10/2018 - 07:29
Sorry from ZC-Zorba
User 02/10/2018 - 07:29
yeah, but do you see other tabs are different names?
Excelchat Expert 02/10/2018 - 07:30
Yeah.
User 02/10/2018 - 07:30
it should follow what the name is
Excelchat Expert 02/10/2018 - 07:30
But I'm not sure what is it you are trying to say.
User 02/10/2018 - 07:30
ok look at Pennies 5375 in ZC Zorba
User 02/10/2018 - 07:30
look at the formulas
User 02/10/2018 - 07:30
then go to ZD-Zorba
User 02/10/2018 - 07:31
Pennies 5375
User 02/10/2018 - 07:31
do you see the difference in the formula
Excelchat Expert 02/10/2018 - 07:31
So you are saying each sheets formula should be different?
User 02/10/2018 - 07:32
yes
Excelchat Expert 02/10/2018 - 07:32
Oh okay. I didn't have that information earlier.
Excelchat Expert 02/10/2018 - 07:32
I will make the amendments.
User 02/10/2018 - 07:32
ok, you sure?
User 02/10/2018 - 07:33
I would look at what the Pennies 5375 say
User 02/10/2018 - 07:33
and it's almost identical
Excelchat Expert 02/10/2018 - 07:33
Hmm, I got the point.
User 02/10/2018 - 07:33
ok
Excelchat Expert 02/10/2018 - 07:36
[Uploaded an Excel file]
Excelchat Expert 02/10/2018 - 07:36
Please check now.
User 02/10/2018 - 07:36
alright I'll check it out
User 02/10/2018 - 07:38
they should all be AL
User 02/10/2018 - 07:38
not AJ
User 02/10/2018 - 07:38
I got it
Excelchat Expert 02/10/2018 - 07:40
You mean =IF($B6<=Setup!$C$4, 'Jan-Other'!$AJ$45, "") should be AL? instead of AJ?
User 02/10/2018 - 07:41
yes
User 02/10/2018 - 07:41
I got it
User 02/10/2018 - 07:41
no biggie
Excelchat Expert 02/10/2018 - 07:41
No No, I can make that change.
Excelchat Expert 02/10/2018 - 07:41
Please allow me a few more minutes.
User 02/10/2018 - 07:41
ok
Excelchat Expert 02/10/2018 - 07:41
Thank you.
User 02/10/2018 - 07:43
you need to add it in tab ZE-Fines
Excelchat Expert 02/10/2018 - 07:44
That changes also need to be applied to ZE-Fines tab?
User 02/10/2018 - 07:44
yes, you missed a tab
Excelchat Expert 02/10/2018 - 07:45
Sorry, that I missed.
User 02/10/2018 - 07:45
oh sorry
User 02/10/2018 - 07:45
I didn't put it in there
Excelchat Expert 02/10/2018 - 07:45
But it was not included in ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
User 02/10/2018 - 07:45
my fault
User 02/10/2018 - 07:45
yes, please add
Excelchat Expert 02/10/2018 - 07:45
I am doing it now.
Excelchat Expert 02/10/2018 - 07:48
[Uploaded an Excel file]
User 02/10/2018 - 07:48
ok, I'll look at it
Excelchat Expert 02/10/2018 - 07:48
I believe this should check out.
User 02/10/2018 - 07:50
ZE-Zorba
User 02/10/2018 - 07:50
you have ZD in AL6
User 02/10/2018 - 07:51
i got this
Excelchat Expert 02/10/2018 - 07:52
Thank you. I'm feeling ashamed. :(
User 02/10/2018 - 07:52
also Other-Zorba
User 02/10/2018 - 07:52
says Jan-ZB
User 02/10/2018 - 07:53
ATP-Zorba is wrong
Excelchat Expert 02/10/2018 - 07:54
Please give me 15 minutes.
Excelchat Expert 02/10/2018 - 07:54
I will ask our support team to send you the corrected file.
User 02/10/2018 - 07:54
I got it
User 02/10/2018 - 07:54
sorry
User 02/10/2018 - 07:54
I'll give you 5 stars
User 02/10/2018 - 07:54
don't worry
User 02/10/2018 - 07:59
ok, I'm done
User 02/10/2018 - 07:59
thank you
User 02/10/2018 - 07:59
I have another one I'll submit

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.