"Dan Lewis" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
Thank you. I'll check the online documentation to see how this is done. Does the actual implementation of this approach work pretty well? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
