# Excel - COLUMN Function Problem - Expert Solution

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

I need a formula which will calculate percent complete (column G) against total number (column J) which will give the remaining units
Solved by V. Y. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 12/04/2018 - 11:15
2017
Excelchat Expert 12/04/2018 - 11:15
hi how are you?
User 12/04/2018 - 11:15
2010
User 12/04/2018 - 11:15
good, have you been able to identify the formula i need?
Excelchat Expert 12/04/2018 - 11:15
is it possible to request for a sample data we could work with?
User 12/04/2018 - 11:16
just pasted into the spread sheet
Excelchat Expert 12/04/2018 - 11:16
Okay, do we need to create a new column for this?
User 12/04/2018 - 11:17
I need a formula that will give me the remaining units. yes.
Excelchat Expert 12/04/2018 - 11:17
okay
Excelchat Expert 12/04/2018 - 11:17
rounded up to the whole number?
User 12/04/2018 - 11:18
yes that is fine
Excelchat Expert 12/04/2018 - 11:18
please see sample row in column K
Excelchat Expert 12/04/2018 - 11:18
no need to round off?
User 12/04/2018 - 11:18
No need to round off
User 12/04/2018 - 11:18
that is exactly what I was looking for
Excelchat Expert 12/04/2018 - 11:18
okay. are you able to see cell K2?
Excelchat Expert 12/04/2018 - 11:19
glad to know. feel free to copy the formula and paste it to the succeeding rows
User 12/04/2018 - 11:19
yes i see it
User 12/04/2018 - 11:19
I am looking at the formula
Excelchat Expert 12/04/2018 - 11:19
is it okay if we mark this problem as ANSWERED?
User 12/04/2018 - 11:19
of course
Excelchat Expert 12/04/2018 - 11:19
great. thanks!
Excelchat Expert 12/04/2018 - 11:20
i can see that you are able to catch up pretty quickly. :)
User 12/04/2018 - 11:20
Thanks
Excelchat Expert 12/04/2018 - 11:20
i'm happy it comes across as a clear solution to you
User 12/04/2018 - 11:20
still a lot to learn
Excelchat Expert 12/04/2018 - 11:20
of course, even I have a lot to learn still :)
Excelchat Expert 12/04/2018 - 11:21
anyway, please feel free to end the session if you don't have any question regarding the solution
Excelchat Expert 12/04/2018 - 11:21
your rating and feedback after ending the session is greatly appreciated too! hope to see you again!
User 12/04/2018 - 11:21
no problem and thank you very much for your quick support

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.