LO 6 OS Mojave
I’m using Advanced Filter to assess a cell range, remove duplicates from it, then display the results in another cell range.
However sometimes I find that text duplicates are not omitted from the resultant cell range, only numeric ones, and other times all duplicates are omitted. I can’t seem to work out why this is happening, it seems to occur randomly sometimes.
Each time I am using the same procedure to remove the duplicates, so don’t see why this should happen other than perhaps some sort of bug…
Is this a known bug, or something else? Any workaround? Does the latest release of LO still have this issue?