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
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
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!
