# median

1. ### MEDIAN IF Contains Matching Text

HI, I'm trying to do the Median equivalent of AVERAGEIF(A1:A10,"*"&C12"&*",B1:B10) where Column C has text some of which is contained within a longer string in Column A and Column B has numerical values that I want to find the median of. I found other threads where this was possible with the...
2. ### Macro help to calculate the median

Hi, im trying to create a macro that enables me to calculate the median of any sequence of numbers provided by the user when the sum of these numbers is> 1000 or the average if this condition is not met. This is one of my first contacts with VB, so I got stuck almost at the beginning, I will be...
3. ### Tough Median Calculation problem

Team, Normally the Median price is calculated on a series of individual prices. Instead, I have a list of prices and the number of times that price was used. Per the image, of course there are many codes and product combinations. Any good Math / Formula guru's who can help a broth
4. ### How to calculate conditional median without accessing worksheet function?

I have a large set of data and I need to calculate the median of certain values which are based on certain conditions in an if statement in a loop - in the code below I need to calculate the median of all the value_1 fields - does someone have code that can be used to calculate a median like...
5. ### Calculate Median from Frequency Table

Hello, does anyone know of a formula to calculate the median from this frequency table? (assuming the list goes on, way beyond row 10) <colgroup><col><col></colgroup><tbody> number frequencies 0 1240 1 2395 2 5538 3 9837 4 14545 5 16061 6 21340 7 25770 8 22434 9 17497 10...
6. ### Median IF returns #NUM! when criteria are not met instead of blank or 0

I am trying to calculate a median based on several criteria. The formula works fine when the criteria are all met, but when they are not I get #NUM !. I would rather it returned a blank or a 0. Here's the formula I'm using...
7. ### PowerBI - calculate difference of two median values

Hi all, Hope you can help me with the following question; I have a couple of columns with data: - Column A consists of numeric data (revenue growth in %) - Column B consists of numeric & Text data (year: 2016, 2017, 2018 and current) - Column C consists of text fields (different geographical...
8. ### Pivot Table - Calculate Median

Hello, I'm in dire need. I need the median values for a set of data, using the pivot table functionality. Is there a way to use the pivot table tool to determine this, similar to how I can quickly identify the average, sum, min, max, etc? Thanks so much!!!
9. ### I Need a formula to show full, partial and zero credit results

Dear Sir or Madam: My name is Robert, and I have just one Excel formula issue. The following formula works perfectly, but I want to add criteria for "0" credit as well. Any assistance you can provide will be greatly appreciated. Sincerely, Robert...
10. ### Median Function within VBA, which accesses an array within the function, not a cell range on the worksheet

I have read the threads about array formulas and I have tried that approach to my problem but it is not working for me. Even doing CSE on each cell and then F9 when data is changed is not working, so I gave up on that, and am now writing my own VBA. I have the VBA function (Median_No_Zeroes)...
11. ### Get MEDIAN from summarized column?

I would like to get a median value for refund checks. My ERP data however lists checks multiple times in the table: Voucher # Voucher \$ Check # Check \$ ABC \$10 001 \$20 DEF \$10 001 \$20 and so on. So it is necessary to...
12. ### Median & Percentile for the range of various lengths

Hi, I am trying to calculate the Median & 75th Percentile for the range in array where the range differs in the length. For example, my data looks like the one given below (my data-set is almost 100,000 rows). Now I am trying to find the median and 75th percentile values of a combined set of 3...
13. ### Formula help

Hello, I need help with a formula. Below is a very small sample size of data I have. Typically, I have thousands of Incident numbers (column A) with hundreds to each Shift-Station(column D). I need to get the median time (column E) for each Shift-Station. Is there an easy formula to type...
14. ### median in Pivot table question

Saw the podcast on calculating median in a pivot table which works great ...except if you have empty/null values....is there a way to ignore the empty cells and calculate median on cells that have value in it?
15. ### MEDIAN with multiple IF conditions

I need to write a formula that calculates a median value, with several IF clauses. EG 'data' tab is below: <tbody> Person Sales Margin Tommy 2 100 Jimmy 3 300 Henry 5 500 Jimmy 4 200 Jimmy 6 100 Tommy 10 200 Henry 3 700 Henry 5 1000 Tommy 7 500 </tbody> In another tab, I...
16. ### Median IFS

Hi all, I'm trying to do a multiple if formula to median response times without counting any blank cells and cells with errors as not all them teams fill in the detail straight away. Here is a sample table <colgroup><col><col><col><col><col></colgroup><tbody> Team Date Respose Date Response...
17. ### Higher, median, & lower

Hi Need some help on this <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> April 11, 2018 March 11, 2018 February 11, 2018 #E67C73[/URL] , align: center"]\$238,912.53 #57BB8A[/URL] , align: center"]\$345,568.02 #FFD666[/URL] , align...
18. ### Median with Multiple Criteria

I'm trying to convert the below averageifs formula to median formula and am having trouble. Help? IFERROR(AVERAGEIFS(SA_Comp[Turnaround],SP_Comp[Individual],\$B\$10,SP_Comp[Request],Stock,SP_Comp[Year],\$B\$3,SP_Comp[Quarter],\$F\$7),"-")
19. ### Conditional Median of Specific Cells

Hi, I hope this makes sense.....:???: I'm trying to calculate the median of salaries that meet a set of criteria. I've looked at other threads, and tried the {=Median(if(A1:A16=criteria,B1:B16))}. This formula works, but it's not returning the median I'm looking for. For example, I want to find...
20. ### calculated measure vs formula?

Hi all, I am trying to figure out how to use a calculated measure as part of an equation for another calculated measure... Basically I'm trying to create a calculated measure to calculate the Coefficient of Dispersion (COD). Excel 2016 has this formula built in, but I'm trying to create it in my...

### This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back