Results 1 to 6 of 6

finding median with criteria

Threaded View

  1. 12-18-2008, 05:21 PM #1
    mheinmiller
    mheinmiller is offline
    Registered User
    Join Date
    09-24-2007
    Posts
    66

    finding median with criteria

    how would I find the median of a group of numbers? I have a database with a group of numbers associated with a part number. I need to find the median of each part. Here is what I have tried, but it doesnt work
    =MEDIAN(IF(A:A=A2,B:B))

    please help
    thanks
    Attached Files Attached Files
    Last edited by mheinmiller; 12-18-2008 at 05:55 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1