# Write Excel statistical ranking formula

I need to develop an Excel formula that does the following:

1. Assess spread of numbers in one column (e.g. numbers may range from 1 - 500)

2. Assign rank of 1 to 10 to each number (in next column), based upon it's value. Rank must be worked out on a volume basis. i.e. the first 10% (of total numbers listed in column) of lowest value numbers are assigned rank 1. The next 10%m, as value increases, will be ranked 2.

This tool must work for any volume of numbers listed in a column. Rank will always be from 1 - 10.

I am sure there is a statistical mathematical term for this - please let me know if you know this.

Thanks

Evner: Excel, Windows Skrivebord

Om arbejdsgiveren:
( 42 bedømmelser ) London, United Kingdom

Projekt ID: #291754

## Tildelt til:

HussienSharaf

HI, i m expert in MS Excel. i can do it using VBA thanks

\$70 USD på 1 dag
(22 bedømmelser)
6.1

## 9 freelancere byder i gennemsnit \$50 på dette job

ioanaprof

\$40 USD på 1 dag
(19 bedømmelser)
4.8
excelinnovation

\$50 USD på 1 dag
(8 bedømmelser)
2.7
lakshmidhanam

Dear Sir, I am ready to work on this project with you.

\$30 USD in 2 dage
(1 bedømmelse)
2.2
latifoglu80

I have it already. Can share with you.

\$30 USD in 0 dage
(0 bedømmelser)
0.0
koolonlove

If I understand correctly, you need to assign a rank figures in the table based on sum of total, would that be correct?

\$75 USD på 1 dag
(0 bedømmelser)
0.0

\$45 USD på 1 dag
(0 bedømmelser)
2.9
MehwishFatima

Hello i m interested in project and i can work in excel with a great ease.

\$60 USD på 1 dag
(0 bedømmelser)
0.0
fitar

i can all these just in 2 days . i have knowledge in Statistics,

\$50 USD in 2 dage
(0 bedømmelser)
0.0