What if analysis in Median (formula help required)

[aravindhan_3]

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-q...-required.html

Regards
Arvind

[p45cal]

Minimum number additional employees at smallest salary (20,000) to get median up I think is:
=COUNTIF(C:C,"<" & F8)-COUNTIF(C:C,">=" & F8)+1
where cell F8 contains that target median of 20,000.

[aravindhan_3]

Hi All,
All of these options worked thanks for your help.

Regards
Arvind