On Wednesday 16 August 2006 11:14 am, 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!
You should create a Base file (database) that connects to your
spreadsheet. Then you should be able to do things like this within
the database. You create a query to separate out all the sales for a
given geographical location. Then it is a matter of doing the
calculations on this information.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
