https://bugs.documentfoundation.org/show_bug.cgi?id=103105
Parijatha Kumar <parijathaku...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #3 from Parijatha Kumar <parijathaku...@gmail.com> ---
I am aware that such a (In reply to brucehohl from comment #1)
> > At the moment, there is no straight forward function to get unique values
> > from a range.
>
> You can use:
> Data > More Filters > Standard Filter
> Select Field name (Column x), Conditions (=), Value (Not Empty)
> Select additional filter criteria if desired ...
> Click 'Options'
> Check 'No duplications'
>
> With 'Copy results to' the results can be written to another range anywhere
> within the workbook.
I am aware of this 'work around'. It does not work for some use cases as below
...
1) What if I've to get unique combinations of cells in two adjacent columns and
one of the cells can contain blank values ?
2) What if I've to apply some more functions like countif etc on the resulting
unique values and display the overall result elsewhere in the document ? Ex.
may be others can add rows in one sheet and the count of unique combinations in
columns A and B is to be displayed in another sheet ?
What I am requesting is for a straight forward function something like unique()
which can take an array (can be multideminesional array i.e., more than one
column).
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
