Hi all,
I have a 'data' spreadsheet sheet for my family medical aid on LO 3.3.1
with multiple columns and different information in each column. Please
see the text example I include below.
What I would ideally like to do is have rows on sheet A, where Column D
is the same, linked onto another sheet(B). My next requirement is to
group all the like column B on sheet B, C and link them onto sheet D but
group them according to column B and SUM the amounts from sheets B, C.
I have included a brief text example below:
Sheet A
A B C D E
20-July SVP SBP Robert 200
20-July STP SPG Hazel 100
21-July STP SBP Robert 180
22-July SVP SBP Robert 50
23-July STP SBP Hazel 400
Sheet B
A B C D E
20-July SVP SBP Robert 200
21-July STP SBP Robert 180
22-July SVP SBP Robert 50
Sheet C
A B C D E
20-July STP SPG Hazel 100
23-July STP SBP Hazel 400
Sheet D
A B C D E
STP SBP Robert 100
STP SBP Hazel 500
SVP SBP Robert 250
I have done some googling regarding row extraction and have also
investigated the SUMIF command. and whilst I can get a total of all the
STP's, I cannot SUM it by user at STP.
The SUMD command has also raised its head but I cannot figure out how to
get it to work in conjunction with SUMIF.
Any help appreciated, even telling me MySQL is a better option. My
problem is that the data is Sheet A is ever growing and being edited by
a basic Excel user, and sheets b->D need to reflect those changes made
on sheet A.
Again, Any Help Appreciated
--
========================================================================
Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO
========================================================================
--
Unsubscribe instructions: E-mail to users+h...@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
