Forum Discussion
Solved
Remove duplicates not working properly
Hello there, I have already searched this forum about this problems but so far I have not found a good answer. I am working with several .csv files with have around 10 columns and 2k lines and I...
- Hello, most likely some of the text has extra spaces. I will advice deploy the =TRIM function.
Let say you have all the values you want to Remove Duplicates in column A1:A100. In column B1, deploy =TRIM(A1).
Copy down the formula.
Then, rum the Remove Duplicates on Column A.
Let me know whether this works
The trim wasn't the problem itself, but I am glad you made me remember it. However, while thinking about your advice of "cleaning" up the cells I realized that there were few characters occupying cells out of the regulares columns. As I wasn't expecting it, I have always been selecting "whole columns" in the remove duplicate option and this few characters have been interfering the results.
I hope this is the real problem. If I need any more advice I will be back here.
Thank you for the help, Abiola1!