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.
