Question description:
This user has given permission to use the problem statement for this
blog.
i want to hide a column but still use it in formula. is this even possible?
Solved by X. E. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/02/2018 - 05:41
Hi
User
27/02/2018 - 05:41
hi
Excelchat Expert
27/02/2018 - 05:41
So hiding a column and using formula based on that column
User
27/02/2018 - 05:42
yes
Excelchat Expert
27/02/2018 - 05:42
Check
Excelchat Expert
27/02/2018 - 05:42
I have hid column B
User
27/02/2018 - 05:42
how did u do that
Excelchat Expert
27/02/2018 - 05:43
Just hide the column B
Excelchat Expert
27/02/2018 - 05:43
But you can use B at any where in the sheet
Excelchat Expert
27/02/2018 - 05:43
That will not be a problem
User
27/02/2018 - 05:43
i am using ms office 2007
Excelchat Expert
27/02/2018 - 05:43
Its fine
User
27/02/2018 - 05:44
no option showing to hide
Excelchat Expert
27/02/2018 - 05:44
It supports in MS OFFICE 2007
Excelchat Expert
27/02/2018 - 05:44
Right click on the column
User
27/02/2018 - 05:44
i did it
User
27/02/2018 - 05:44
thanks
Excelchat Expert
27/02/2018 - 05:44
Found?
User
27/02/2018 - 05:44
yes
Excelchat Expert
27/02/2018 - 05:44
Great!
Excelchat Expert
27/02/2018 - 05:44
Thats it then
User
27/02/2018 - 05:44
i need a formula to update balance
Excelchat Expert
27/02/2018 - 05:45
You can attach the sheet if you have the work
Excelchat Expert
27/02/2018 - 05:45
I can work on that based on your requirement
Excelchat Expert
27/02/2018 - 05:47
You there?
User
27/02/2018 - 05:48
sorry thats not possible. but here is the detailed question. in M3 column i have a formula to calculate profit/loss i need a formula to update balance in N column . for example my inital balnce is 100 usd. if profit is 5 usd in m column . n column should update 105usd. if loss is -3 usd . n column should show 97 usd
Excelchat Expert
27/02/2018 - 05:49
Check
Excelchat Expert
27/02/2018 - 05:50
Column A is your N
Excelchat Expert
27/02/2018 - 05:50
And B is M
Excelchat Expert
27/02/2018 - 05:50
A1 is the initial balance
User
27/02/2018 - 05:52
thanks got it
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.