Hello,

I have a list

A B
1 a 20
2 b 25
3 c 30
4 d 35
5 e 25

I would like to be able to have column C to list column a from largest to
smallest and column D to list the associated numbers with that. Taking into
consideration that a b and e have the same value. So what I am looking for
will look like this

C D
1 d 35
2 c 30
3 b 25
4 e 25
5 a 20

Can anyone help. I believe it will have to be an index match formula of
some sort but I am not sure how to procede.

Thanks in advance,

Eyad