https://bugs.documentfoundation.org/show_bug.cgi?id=103105
--- Comment #5 from Eike Rathke <er...@redhat.com> ---
(In reply to Parijatha Kumar from comment #3)
> 1) What if I've to get unique combinations of cells in two adjacent columns
> and one of the cells can contain blank values ?
You set up a helper column that concatenates the adjacent cells. A UNIQUE
function will not help there. Or I misunderstood.
> 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 ?
How is that in any way related to a UNIQUE function?
> 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).
Note that to work correctly a UNIQUE function would have to output an array of
rows. After being entered the first time the output array size would be fixed
to the then number of unique values. If data was added to the original range,
the range the UNIQUE function occupies / outputs to would *not* be extended, so
would be pretty much useless then and would have to be re-entered, deleting the
original range first. The situation is not much different from the
filter-unique-to functionality, on the opposite, it would be even more
cumbersome.
--
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
