median salary value in range in Excel
Q38. In Excel, how do I find the median salary of employees with the same skillset in my Organization?
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.