Excel - COLUMN Function Problem - Expert Solution

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

I have a column of numbers with many duplicates. I need to remove the duplicates.
Solved by G. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/08/2018 - 07:51
Hello, Welcome to Got it Pro.
User 29/08/2018 - 07:51
Hi. I have a column of thousands of numbers, with many of the numbers being the same.
User 29/08/2018 - 07:51
I need a list of just the unique numbers without having to go through and manually remove the duplicates
Excelchat Expert 29/08/2018 - 07:52
Ok, and you want to remove the duplicate numbers from the column, right?
User 29/08/2018 - 07:52
Yes
Excelchat Expert 29/08/2018 - 07:52
if you want me to do that, please forward me the sheet
User 29/08/2018 - 07:52
I cannot forward you the sheet. Please just tell me how to do it
Excelchat Expert 29/08/2018 - 07:52
ok
Excelchat Expert 29/08/2018 - 07:53
Select the column in which you have the numbers.. select the whole column
User 29/08/2018 - 07:53
ok
Excelchat Expert 29/08/2018 - 07:53
Click on Data tab
User 29/08/2018 - 07:53
ok
Excelchat Expert 29/08/2018 - 07:54
then click on remove duplicates
Excelchat Expert 29/08/2018 - 07:54
what it is saying now?
User 29/08/2018 - 07:55
It worked.
Excelchat Expert 29/08/2018 - 07:55
Did it solve your query?
User 29/08/2018 - 07:55
Can I tell it to delete all cells that contain a certain combincation of numbers?
Excelchat Expert 29/08/2018 - 07:56
Yes you have to select that column
Excelchat Expert 29/08/2018 - 07:56
and then go for remove duplicates
User 29/08/2018 - 07:56
No, I mean:
User 29/08/2018 - 07:56
I have a list of numbers
Excelchat Expert 29/08/2018 - 07:56
ok
User 29/08/2018 - 07:57
Can I tell it to delte all of the cells contain certain numbers as part of the cell?
User 29/08/2018 - 07:57
So, say, a cell has the number 464613174123 in the cell
Excelchat Expert 29/08/2018 - 07:57
ok
User 29/08/2018 - 07:57
I want to tell it to delete any cells that contain "123"
Excelchat Expert 29/08/2018 - 07:57
No it wont work that way
User 29/08/2018 - 07:57
So that cell would be deleted because it has 123 in the number
Excelchat Expert 29/08/2018 - 07:58
We have to look at the data and create the logic and then we can look for solution.
Excelchat Expert 29/08/2018 - 07:58
There isnt a direct way to do this
Excelchat Expert 29/08/2018 - 07:58
Anything else, I can help you with?
User 29/08/2018 - 07:59
No. Thanks
Excelchat Expert 29/08/2018 - 07:59
Please end the session and provide 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time.
Excelchat Expert 29/08/2018 - 07:59
Thanks for using Got it Pro. Looking forward to help you further.

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