[Libreoffice-bugs] [Bug 137763] Aggregate(1; 6; ..) (Avg): different conditions => same value or single values and not the average

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Oct 26 10:21:14 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=137763

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
An unrelated note: you may optimize the formula in G11 to be
'=IF(E11=F11;E11;E11&F11)', if you only expect "Se" and "Bu" there, or if you
are OK with simple concatenation of the different cell values.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201026/0fdcbcf9/attachment.htm>


More information about the Libreoffice-bugs mailing list