Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: median value based on criteria in two other columns

  1. #1
    Join Date
    17th May 2011

    median value based on criteria in two other columns

    Need a formula to calculate: median of the numbers in column C thate are greater than "0" based on a specific criteria in column A and also specific month in column "B".

    eg: i want the median prices for the sales in mosman (multiple sububs in column) in april (multiple months in the column)

    spreadsheet attached

    thanks in advance for anyones help
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    19th January 2007
    South Carolina, USA

    Re: median value based on criteria in two other columns

    Please do not create duplicate threads.

    You've already asked this question and received a reply in your other thread:

    Calculate median without zeros based on another column criteria

    Discussion may continue in your original thread.

    Forum Rules | Message to Cross Posters | How to use Tags

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 1
    Last Post: May 18th, 2011, 09:07
  2. Calculate median based on criteria
    By gregh in forum EXCEL HELP
    Replies: 1
    Last Post: May 16th, 2011, 11:55
  3. Replies: 3
    Last Post: January 1st, 2008, 11:51
  4. Hiding Columns Based On Criteria
    By Dangerous_ in forum EXCEL HELP
    Replies: 3
    Last Post: December 8th, 2006, 01:40
  5. median of numbers of corresponding columns
    By mcrae in forum EXCEL HELP
    Replies: 6
    Last Post: May 11th, 2006, 22:14


Posting Permissions

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