Remove duplications

Hi!

If anyboody could help me with how to remove doublets from my LibreOffice Calc? I have a lot of keywords saved, but almost all of them are doublets :(…I tried to check the “no duplications” box in the “data” section but it says “Invalid sheet reference”, and then “This range does not contain a valid query.”. What am l doing wrong? Please help me, thanks!

Henrik

I found out :)…

Please write how you solve the issue, can help other people.

Ofc, l found this video https://www.youtube.com/watch?v=7rZcnBDzfRA