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 543 views

## 1 answer to this question.

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))`
• 63,720 points

## Repeated excel rows based on a cell with multiple values

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

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

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

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

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

## 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

## 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

## How to calculate median of unsorted values

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

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

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

## Retrieve epay.info Balance with VBA and Excel

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