aravindhan_3
01-27-2016, 01:07 AM
Hi,
I am using a simple median formula in cell D1 = Median(C:C), there are about 350000 rows of employee numbers in column A & Names in Col B & Salaries in Col C .
Assume the median value is 18567 in Cell D1. now if I want to get median value to become 20000, how many more employee to be recruited ( rows to be added) and with what salary.
Not sure if the is easy or difficult to do in formulas.
Thanks for your help
Cross post :- http://www.mrexcel.com/forum/excel-questions/917052-what-if-analysis-median-formula-help-required.html
Regards
Arvind
I am using a simple median formula in cell D1 = Median(C:C), there are about 350000 rows of employee numbers in column A & Names in Col B & Salaries in Col C .
Assume the median value is 18567 in Cell D1. now if I want to get median value to become 20000, how many more employee to be recruited ( rows to be added) and with what salary.
Not sure if the is easy or difficult to do in formulas.
Thanks for your help
Cross post :- http://www.mrexcel.com/forum/excel-questions/917052-what-if-analysis-median-formula-help-required.html
Regards
Arvind