Results 1 to 3 of 3

Median calculation across two columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Median calculation across two columns

    Apologies if this is a simple query, I have struggled to find an obvious solution on the wider web, though.

    I am trying to calculate the median sale price across a total number of sales. Total 2046 sales at 17 different prices.

    The data is in two columns. The first column contains the unit price. The second column contains the number of sales of that unit at that price.

    Data in the attachement.

    Any assistance appreciated.
    Attached Files Attached Files
    Last edited by captainjazz; 06-21-2011 at 08:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1