I tried to remove duplicate rows of the same column in LibreOffice by using
Data->More Filters->Advanced Filter then selected the whole column and checked
Looking at the docs online this should leave me with a unique text entries, but I get an error
This range does not contain a valid query.
Does it mean that I am doing something wrong or this filter cannot be applied to text entries?