# 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

Kemahiran: Excel, Destop Windows

Tentang Majikan:
( 42 ulasan ) London, United Kingdom

ID Projek: #291754

HussienSharaf

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

\$70 USD dalam sehari
(22 Ulasan)
6.1

## 9 pekerja bebas membida secara purata \$50 untuk pekerjaan ini

ioanaprof

\$40 USD dalam sehari
(19 Ulasan)
4.8
excelinnovation

\$50 USD dalam sehari
(8 Ulasan)
2.7
lakshmidhanam

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

\$30 USD dalam 2 hari
(1 Ulasan)
2.2
latifoglu80

I have it already. Can share with you.

\$30 USD dalam 0 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0

\$45 USD dalam sehari
(0 Ulasan)
2.9
MehwishFatima

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

\$60 USD dalam sehari
(0 Ulasan)
0.0
fitar

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

\$50 USD dalam 2 hari
(0 Ulasan)
0.0