also sprach Stefan Weigel <[email protected]> [2014-09-19 18:55 +0200]: > This formula in A1 should behave as you desire: > =OFFSET($B$1;0;ROW()-ROW($B$1))
Yeah, I've since found OFFSET() as well, but as you can imagine, my functions aren't just simple references, and using OFFSET() actually makes it totally unreadable. Tbh, I was also wondering why this isn't a use-case for a pivot table, given that I simply pivot data 90°… -- @martinkrafft | http://madduck.net/ | http://two.sentenc.es/ a qui sait comprendre, peu de mots suffisent. -- intelligenti pauca spamtraps: [email protected] -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
