thanks for the help.most of the queries solved.particularly the "COMANDIF" function is really a brilliant one.now stuck in one last table.could not understand how to solve this one?went through *output revised* ,but still... in this i need to express the BMI data wrt age(the row contains >30yrs & <30yrs and the column contains BMI>25 & <25).could not understand how to do this!!!!!!!!! anyway probably my brain stopped functioning.will check again tomorrow. btw,how to sort column data obtaining from formula?i mean for the BMI column-i used the formula and did not put the data individually.now i could not sort it either in ascending or descending order.the columns in which i typed the data could be sorted but not the columns in which data is generated using formula. thanks a lot for your help;really appreciate it.
On 7 August 2011 02:52, planas <[email protected]> wrote: > ** > Hi > > No problem, I put some more information in the Output file as Output > Revised. Hope this answers your questions, Dr Ray > > On Sat, 2011-08-06 at 11:39 +0100, Tom Davies wrote: > > Hi :) > I am forwarding Dr Ray's spreadsheet in case it helps. I haven't woken up > yet so i haven't made sense of the question. > Regards from > Tom :) > > > > ----- Forwarded Message ---- > *From:* soumalya ray <[email protected]> > *To:* [email protected] > *Cc:* [email protected] > *Sent:* Sat, 6 August, 2011 6:36:58 > *Subject:* how to have output in table from calc data? > > hi, > i searched for this but since i am totally new to calc i could not even > understand what to search for. > i have calc sheet named "students demography" with the > name,age,gender,wt,height,BMI,sponsored candidate or not etc.now i need to > make tables for comparing the data.say the row header contains *BMI >30 & > BMI <30* and the column of the table contains *male & female*. > what is the way to have this output from the calc data? > @tomdavies i am attaching a proforma of the calc sheet and the expected > output. > any help will be highly appreciated.thanks in advance > > > -- > Dr soumalya ray <http://drsoumalya.blogspot.com> <[email protected]> > MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) > Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp> > > > > > -- > Jay Lozier > [email protected] > -- Dr soumalya ray <http://drsoumalya.blogspot.com> <[email protected]> MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp> -- 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
