Excel - COLUMN Function Problem - Expert Solution

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

I need to delete additive inverse of numbers. For eg. column A contains value 234 and -234. How to delete both values from a large dump of numbers?
Solved by V. L. in 33 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 27/02/2018 - 11:34
Hi
Excelchat Expert 27/02/2018 - 11:47
Here
[Uploaded an Excel file]
Excelchat Expert 27/02/2018 - 11:47
Col B and C are helpers
Excelchat Expert 27/02/2018 - 11:47
You can hide these two
Excelchat Expert 27/02/2018 - 11:47
Col D is your output
Excelchat Expert 27/02/2018 - 11:48
for col A
Excelchat Expert 27/02/2018 - 11:48
you there?
Excelchat Expert 27/02/2018 - 11:50
version2
[Uploaded an Excel file]
Excelchat Expert 27/02/2018 - 11:52
you can hide col B,C and D
Excelchat Expert 27/02/2018 - 11:52
These are helper columns
Excelchat Expert 27/02/2018 - 11:54
you there?
User 27/02/2018 - 11:54
hey
Excelchat Expert 27/02/2018 - 11:54
HI I have sent two files
User 27/02/2018 - 11:54
sorry to miss last conversations
Excelchat Expert 27/02/2018 - 11:54
Please check those
Excelchat Expert 27/02/2018 - 11:55
Have you got the files?
User 27/02/2018 - 11:57
yes i've got them
User 27/02/2018 - 11:57
ng those
User 27/02/2018 - 11:57
give me a minute
Excelchat Expert 27/02/2018 - 11:57
sure
User 27/02/2018 - 11:57
checking those*
Excelchat Expert 27/02/2018 - 11:57
ok
User 27/02/2018 - 12:01
thanks a lot
User 27/02/2018 - 12:01
it helped
Excelchat Expert 27/02/2018 - 12:01
:)
Excelchat Expert 27/02/2018 - 12:01
most welcome
Excelchat Expert 27/02/2018 - 12:02
If you leave please give me ratings after ending the chat
User 27/02/2018 - 12:07
sure

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
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc