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
may be it caused by using dash or underline etc. in your data, for ex.:
1234
1234-1
4321