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 case, i am trying to filter the data. regards,
SUMPRODUCT($A$1:$A$5="this";$B$1:$B$5="that") A1*B1 => 1 or 0 A2*B2 => 1 or 0 A3*B3 => 1 or 0 A4*B4 => 1 or 0 A5*B5 => 1 or 0 ----------------- Result: Sum of products -- 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
