How to calculate these numbers using excel function .

[Sunline]

Hello all ,

I am wanting to give a percentage number based on 14,654 races where these horses came
1st to 18th and a few falls and pulled up etc .

Bacically I want to give more credit to those who have a higher number in col B but I don’t know
how to evaluate this from my 14,654 races .

Any help will be great . Looking for some basic functions or ideas .

Thanks .

Excel Workbook
	A	B	C
1	Placing	Qty	Result
2	1	809
3	2	1057
4	3	736
5	4	619
6	5	536
7	6	451
8	7	345
9	8	242
10	9	197
11	10	151
12	11	110
13	12	65
14	13	47
15	14	19
16	15	5
17	16	3
18	17	0
19	18	0
20	B	2
21	F	6
22	LR	10
23	P	8
Sheet3

 

[mole999]

Excel Workbook
	A	B	C	D
1	Placing	Qty	Result
2	2	1	809	14.9%
3	3	2	1057	19.5%
4	4	3	736	13.6%
5	5	4	619	11.4%
6	6	5	536	9.9%
7	7	6	451	8.3%
8	8	7	345	6.4%
9	9	8	242	4.5%
10	10	9	197	3.6%
11	11	10	151	2.8%
12	12	11	110	2.0%
13	13	12	65	1.2%
14	14	13	47	0.9%
15	15	14	19	0.4%
16	16	15	5	0.1%
17	17	16	3	0.1%
18	18	17	0	0.0%
19	19	18	0	0.0%
20	20	B	2	0.0%
21	21	F	6	0.1%
22	22	LR	10	0.2%
23	23	P	8	0.1%
Sheet1

 

[Sunline]

Great , thanks .