...@gmail.com wrote:
From: soumalya ray drsouma...@gmail.com
Subject: Re: [libreoffice-users] Re: what is the alternative of countifs
function in libreoffice?
To: users@global.libreoffice.org
Date: Sunday, 29 January, 2012, 7:27
yeah and then 10 min to check whether i made any mistake or not!
:D
Am 29.01.2012 08:27, soumalya ray wrote:
yeah and then 10 min to check whether i made any mistake or not!
:D :D
regards,
Since I know the usual navigation keys and fill methods with all the
availlable keyboard shortcuts, I am always sure to do the right thing in
*any* spreadsheet.
Simply
Hi soumalya ray
soumalya ray wrote
yeah and then 10 min to check whether i made any mistake or not!
:D :D
This kind of answers will only cause people to stop helping you. One
solution was given to you 2 days ago, and yet you don't want to waste 10
minutes. That shows how committed you are
Am 28.01.2012 05:47, soumalya ray wrote:
its really time consuming.is there any other way to achieve this?
regards,
3 seconds.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting
yeah and then 10 min to check whether i made any mistake or not!
:D :D
regards,
On 29 January 2012 02:17, Andreas Säger ville...@t-online.de wrote:
Am 28.01.2012 05:47, soumalya ray wrote:
its really time consuming.is there any other way to achieve this?
regards,
3 seconds.
--
For
soumalya ray wrote
now i am trying to include the row/column percentage into the data pilot
result directly along with the absolute count.so far, no luck!!
I guess you just bumped into the LO Pivot Table limitations (compared to MS
Office)
In MS Office you would just add again the same
Am 27.01.2012 11:23, Pedro wrote:
I'm almost sure that you can't do that in the LibreOffice Pivot Tables
(unless there are some undocumented features that I'm not aware of? )
You can select multiple functions for the same data field. The function
selector is a multi-select list box.
Indeed,
sorry;could not understand the meaning of 'duplicate the field'.could you
explain a bit more please?
regards,
On 27 January 2012 17:05, Andreas Säger ville...@t-online.de wrote:
Am 27.01.2012 11:23, Pedro wrote:
I'm almost sure that you can't do that in the LibreOffice Pivot Tables
(unless
Am 27.01.2012 19:04, soumalya ray wrote:
sorry;could not understand the meaning of 'duplicate the field'.could you
explain a bit more please?
regards,
Create a calculated field with nothing but a reference to the field you
need twice.
--
For unsubscribe instructions e-mail to:
its really time consuming.is there any other way to achieve this?
regards,
On 27 January 2012 23:57, Andreas Säger ville...@t-online.de wrote:
Create a calculated field with nothing but a reference to the field you
need twice.
--
For unsubscribe instructions e-mail to:
ok,data pilot works.i tried it earlier also but somehow missed the
'clicking data field and change the function' part.thanks for the link
@stefan.
@andreas, could not understand how to use sumproduct in my case.is it not a
way of multiplication? in my case, i am trying to filter the data.
regards,
Am 26.01.2012 09:42, soumalya ray wrote:
ok,data pilot works.i tried it earlier also but somehow missed the
'clicking data field and change the function' part.thanks for the link
@stefan.
@andreas, could not understand how to use sumproduct in my case.is it not a
way of multiplication? in my
Am 25.01.2012 18:26, Stefan Weigel wrote:
Hi,
Am 25.01.2012 17:16, schrieb soumalya ray:
say,in one column gender of the participants are written (male/female).in
next column height of the participant is written.now i want to count how
many females have height=1.55 metre.
+1 for the data
13 matches
Mail list logo