< Go Back

Excel - COLUMN Function Problem - Expert Solution

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

Trying to figure out what is wrong with my formula in Oct-ZD tab in column AY and BG.

Solved by O. Q. in 8 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User 10/10/2018 - 08:17
Hello
Excelchat Expert 10/10/2018 - 08:18
Welcome to ExcelChat!
Excelchat Expert 10/10/2018 - 08:18
I see that your question is about formula update. I will help you with the problem and explain the solution afterwards.
Excelchat Expert 10/10/2018 - 08:18
Before we get started, this is a reminder that our policy is one problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 10/10/2018 - 08:18
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 10/10/2018 - 08:18
Could you please share a file where you have the problem?
User 10/10/2018 - 08:19
ok [Uploaded an Excel file]
User 10/10/2018 - 08:19
ok so if you go to the Oct-ZE tab
User 10/10/2018 - 08:19
you'll see column AY and BG are giving me a problem with #VALUE!
Excelchat Expert 10/10/2018 - 08:20
One moment, will check that
User 10/10/2018 - 08:20
can you help me with that for tabs Oct-Z tabs?
User 10/10/2018 - 08:20
ok thank you
Excelchat Expert 10/10/2018 - 08:22
The problem is because in AD10 you have "-"
Excelchat Expert 10/10/2018 - 08:23
Once you delete it, the problems are gone
User 10/10/2018 - 08:23
oh ok, let me see
User 10/10/2018 - 08:23
I didn't even think of tha
User 10/10/2018 - 08:23
that
Excelchat Expert 10/10/2018 - 08:23
The thing that this cell is used in the calculation, and when we try to do the math operations with the symbol, which is text, it returns an error
Excelchat Expert 10/10/2018 - 08:24
I just checked all the related elements, and ended with that cell
Excelchat Expert 10/10/2018 - 08:24
It was the reason of multiple errors
User 10/10/2018 - 08:25
ok, look at tab Oct-ZD
User 10/10/2018 - 08:25
cell BG9
Excelchat Expert 10/10/2018 - 08:25
The same reason - please remove all the "-" from your cells
User 10/10/2018 - 08:25
i deleted "-" and it's still giving error
User 10/10/2018 - 08:26
oh
User 10/10/2018 - 08:26
nevermind
Excelchat Expert 10/10/2018 - 08:26
When you use 0 and it is shown as "-" it is okay
User 10/10/2018 - 08:26
I got it
Excelchat Expert 10/10/2018 - 08:26
But when you just type the "-" - it is text
User 10/10/2018 - 08:26
5 - star
User 10/10/2018 - 08:26
yup, I got it
Excelchat Expert 10/10/2018 - 08:26
You are welcome, it was a pleasure to assist you! If it happens that you have any Excel or Google Sheets problems in future, please don't hesitate to reach us again.
User 10/10/2018 - 08:26
thanks
Excelchat Expert 10/10/2018 - 08:26
You may now end the session, I would highly appreciate if you rate our session at the end and leave some feedback. Have a nice day!

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 privacy is guaranteed. Your session will not be used for blog unless you give us persmission.