Formula for Percentiles Needed

[rusted314]

Hi,
I am trying to calculate the 10th, 50th and 90th percentiles for salaries of managers in different states ie.

State Job Salary
CO Manager $50000
CO Asst. Manager $45000
CO Manager $60000
CO Asst. Manager $55000
NH Manager $80000
NH Asst. Manager $65000
NH Manager $90000
NH Asst. Manager $75000
VT Manager $30000
VT Asst. Manager $25000
VT Manager $40000
VT Asst. Manager $35000

The percentile formula seems to work fine if I want to calculate all of the data however I need it broken out by State and Job. Any Ideas?

Thanks

 

[Herbert Seidenberg]

Excel 2010, Tables, PivotTable
10th, 50th, 90th Percentile
Multiple criterias
http://c3017412.r12.cf0.rackcdn.com/04_22_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm