[libreoffice-users] Re: Fw: how to have output in table from calc data?

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 <jslozier@gmail.com> 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 <drsoumalya@gmail.com>
> *To:* users@global.libreoffice.org
> *Cc:* tomdavies04@yahoo.co.uk
> *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>  <drsoumalya@gmail.com>
> MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine)
> Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp>
>
>
>
>
>   --
> Jay Lozier
> jslozier@gmail.com



-- 
Dr soumalya ray <http://drsoumalya.blogspot.com>  <drsoumalya@gmail.com>
MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp>

-- 
For unsubscribe instructions e-mail to: users+help@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