I was too fast... |--A---|----B----|----C----| |WH1| Item1 | 10 | |WH2| Item1 | 20 | |WH1| Item2 | 20 | |WH3| Item2 | 10 | |WH1| Item3 | 15 |
Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer T +32 56 43 42 45 • F +32 56 43 44 46 • [email protected] TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com On 26 March 2013 15:26, Dries Feys <[email protected]> wrote: > Hello, > > I received today a question about a spreadsheet I can't answer > immediately. Though I'm convinced this must be possible. > > We have a sheet with > A : stock location > B : item n° > C : quantity > > The user wants now the sum per item, preferable in another sheet with > the same layout, or in a automatically generated accumulated line. > > In the help I can see something about array formulas, which seems > interesting, but I want an automatic break per item no. > > Example > > |--A---|----B----|----C----| > |WH1| Item1 | 10 | > |WH1| Item1 | 10 | > |WH1| Item1 | 10 | > |WH1| Item1 | 10 | > |WH1| Item1 | 10 | > > > Met vriendelijke groeten, Salutations distinguées, Kind Regards, > > DRIES FEYS > CORPORATE SERVICES • Specialist Software Developer -- **** DISCLAIMER **** http://www.tvh.com/newen2/emaildisclaimer/default.html "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- For unsubscribe instructions 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
