Excel Median of even number of values with a condition

0 votes
When I calculate the median of even numbers for e.g 1,2,3,4,5,6,7,8. I want the return value to be 5 i.e. the higher value of the two middle values and not the average of 4 & 5. Can someone help me with this?
Nov 26, 2022 in Others by Kithuzzz
• 38,000 points
640 views

1 answer to this question.

0 votes

The LARGE function, COUNT function, and TRUNC function should all be used in conjunction to achieve this, in my opinion. For instance, using the formula, even though it technically isn't the median, you should be able to find the desired result if the numbers you are dealing with are in cells A1 through A8.

=LARGE(A1:A8,TRUNC((1+COUNT(A1:A8))/2))
answered Nov 26, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Repeated excel rows based on a cell with multiple values

You can use this query: let ...READ MORE

answered Oct 20, 2022 in Others by narikkadan
• 63,600 points
1,541 views
0 votes
1 answer

Excel - Make a graph that shows number of occurrences of each value in a column

There is probably a better way to ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,600 points
9,441 views
0 votes
1 answer

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,600 points
1,158 views
0 votes
1 answer

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,600 points
3,440 views
0 votes
1 answer

Help needed with Median If in Excel

Try entering the formula =MEDIAN(IF($A$1:$A$6="Airline",$B$1:$B$6,"")) in another ...READ MORE

answered Nov 10, 2022 in Others by narikkadan
• 63,600 points
907 views
0 votes
1 answer

How to calculate median of unsorted values

In vba code: Dim r As Range Dim result 'Set ...READ MORE

answered Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
606 views
0 votes
1 answer

How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,560 points
7,047 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,254 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,600 points
1,117 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,600 points
894 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP