Formula to rank list in order from 1 down

[sobrien1234]

In column A I have ranked people from 1 (best) down to 100 (worst) but they appear randomly.
In column B I have names of the people.

I need a formula that I can copy down for column C (which re-orders the rank numbers in column A) and column D (that reorders the names accordingly) that puts them in ascending order.

Note - some of the people may have the same rank number.

I understand that I can use the autofilter and resort in ascending order but this is impractical for what I need to do.

Thanks

 

[sandy666]

maybe Ctrl+T then sort rank ascending

 

[sobrien1234]

Sorry has to be a formula

 

[sandy666]

no problem

have a nice day

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1
2	1	abc	1	abc
3	2	def	2	def
4	5	ghi	2	stu
5	7	jkl	3	vwx
6	9	mno	5	ghi
7	10	pqr	7	jkl
8	2	stu	9	mno
9	3	vwx	10	pqr
Orders

Cell Formulas
Range	Formula
C2	=SMALL(A$2:A$9,ROWS(A$2:A2))
D2	{=INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=C2,ROW($B$2:$B$9)-1),COUNTIF(C$2:C2,C2)))}
Press CTRL+SHIFT+ENTER to enter array formulas.