Please recommend rank automatically formula

[febausa]

DRAW	BALL	BALL	BALL	BALL	BALL	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60	61	62	63	64	65	66	67	68	69	70	71	72	73	74	75
DATE	#1	#2	#3	#4	#5
11/22/2013	54	56	11	48	10											10	11																																					48						54		56
11/22/2013	49	11	6	41	13							6					11		13																												41								49
11/22/2013	53	24	13	25	36														13											24	25											36																	53

<colgroup><col><col span="5"><col><col span="75"></colgroup><tbody>
</tbody>

 

[Skybluekid]

This should do the trick https://www.dropbox.com/s/wvlb7vi4gcn5wsq/Automatic Rank.xlsx