Hi,
what are the requirements for the data type to successfully remove duplicates in Calc? And what format has to be used?
I am asking since I encountered several problems using this “no duplicates” filter function.
-
It does not work when: changing the number format, like decimal mark from “.” to m “,”
-
It does not work when: using long numbers like 1,124087102847107401824701E22
or 5,17247120410710247091470197 -
It changes data when used on data like “A 1”
Plz help! Thx!