Results 1 to 3 of 3

MedianIf... using Lookup?

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2011
    Location
    Huntsville, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    12

    Question MedianIf... using Lookup?

    Hi everyone,
    I have 2 columns, one contains a number and the other contains either 1 or 0. I want to calculate the median of all the values in the first column for which the value in the second column is 1.
    I have tried using the Lookup function and I cannot get it to correctly identify even one of the values.

    Any help is appreciated, thanks
    Last edited by lady_Jane; 07-05-2011 at 11:54 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