Attached is a 16KB spreadsheet that will do as you ask.
The newsgroup server will strip off the attachment, but
I am including your email address as well so that you will
get the attachment.

Joe Conner

Franco wrote:
Hi,
Could someone please steer me in the direction for the following?

Let's say I have sales records for lots of transactions (represented by rows
in a spreadsheet).  Three of the fields are geographic location, sales
price, and size.  If I want to calculate the median price for just records
in a certain geographic area and a certain size, how would I write that
function?

Thanks!



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  

Attachment: Franco Test.ods
Description: application/vnd.oasis.opendocument.spreadsheet

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to