https://bugs.documentfoundation.org/show_bug.cgi?id=145569
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #1 from Mike Kaganski <[email protected]> --- This is not a bug. The COUNTIFS function [1] accepts "Criterion" argument, which is described in the help. Namely, if you use a string starting with "=", it must be followed by a *value*, not by a reference. You have these options: 1. =COUNTIFS(A$1:A$64;"=" & A1) 2. =COUNTIFS(A$1:A$64;A1) > remove (not hide) duplicates would be nice, but is not part of the bug Just select *original data* on the first sheet, use Data->More Filters->Standard Filter, and use "No duplications" and "Copy results to", which will allow you to copy without duplications. Also there is a "Remove Duplicates Fast" extension [2]. [1] https://help.libreoffice.org/7.2/en-US/text/scalc/01/func_countifs.html?DbPAR=CALC [2] https://extensions.libreoffice.org/en/extensions/show/remove-duplicates-fast -- You are receiving this mail because: You are the assignee for the bug.
