https://bugs.documentfoundation.org/show_bug.cgi?id=144017
John Murrell <bug2...@johnmurrell.org.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|UNCONFIRMED |RESOLVED --- Comment #2 from John Murrell <bug2...@johnmurrell.org.uk> --- Ok, The function COUNTIFS does something similar to what I was proposing. So I will close this. However COUNTIFS does not actually work in my application, I think because the list of random numbers re-calculates each time COUNTIFS runs so the results keep on changing. As a result when you filter on the COUNTIFS >1 you it does not show the duplicates and takes about 1/2 hour to run. Not sure if this is a bug or expected behaviour but the only way it appears to get the duplicated results is to use a pivot table or do a filter on the cell colours when the filtering on conditional results bug is fixed. -- You are receiving this mail because: You are on the CC list for the bug.