https://bugs.freedesktop.org/show_bug.cgi?id=58687
--- Comment #2 from Eike Rathke <[email protected]> --- I don't think a UNIQUE function is a good idea. Such function would need to return an array that would change its size with data change. An array formula has a fixed return size, while removing entries from that return array and displaying #N/A for non-available entries is possible, adding entries is not. Formulas are not meant to overwrite cells that do not belong to the formula. It's also not "some strange set up and an advanced filter" you need. All you have to do is select the data range, go to Data->Filter->StandardFilter, select the field to query with Condition '=' and the special value "Not Empty", and in More Options choose "No duplication" and let the output be generated starting at a defined cell reference with "Copy results to". That is the standard spreadsheet procedure to generate a list of unique values from a set of data. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
