Median salary value in range in Excel To do it in Excel, here is the answer: a) Select the range with Salary for Employees with the same skillset. To get Median Salary, enter formula =MEDIAN(CH5:CH14) where CH5:CH14 corresponds to the range with Employee Salaries. You can find similar Excel Questions and Answer hereunder 1) How can I fill a range of cells with incremental times? 2) How can I find the sum of records that meet a given condition in my raw data table? 3) Is there a way I can average a range of numbers even if there is an error value in range? 4) How can I set up a dynamic named range that expands automatically when new items are added to the list? 5) How to read a value from a cell in vba in Excel 6) How can I get an estimate of Standard Deviation of a sample dataset? 7) How can I find the slab in which a given value fits? 8) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret? 9) I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option? 10) Is there a way to easily shade alternate rows in a data range for improving readability?