Remove Duplicates

[FatimaAlcaraz]

Good afternoon!
I am having problems to be able to eliminate duplicates in a range of data since the Remove duplicates action does not work for me, I do not know if it is only me that is not applying it in a good way or what would be my mistake. But I need to remove duplicates between this range. A1:F30.

[PvD_SE]

Hi Fatima,

For new questions, please post a new thread. 

I'll try and formulate an answer to your latter question, although the question is quite unclear.
The action you chose to get CSV data into a collection is the correct one. It either works or it does not. If it does not, usually all row data is collected in only one collection column. If this is the case, check the below:
Search windows for 'region' and select the 'region settings' and click on 'additional date, time, &regional settings', you get a new window. Now click 'change date, time, or number formats' and then 'additional settings', this will pop a window called 'customize format'. Check the value for 'List separator', this is likely either a , or a ; (comma or semicolon). Change to whatever it is that you have in you CSV and click 'Apply' and 'Ok'. Then try again.

Finally, in some cases, the comma or semicolon in your CSV might be of a different character set that windows is currently handling, in such cases, open the CSV with Notepad++ and search and replace the comma in the CSV for a proper comma, then try again.

...and yes, windows is a bit of a drag...

In future: Please explain what it is you want to know in a format similar to below:
- This is what I have
- This is what I do
- This is what I get
- This is what I want to have instead
- How do I do to get the result I want?

Regards,
Paul
Sweden