Re: [libreoffice-users] Fill down with a twist.

also sprach Stefan Weigel <stefan.weigel@bildungskreis.org> [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: madduck.bogus@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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