number col B referring to col A descending order

[carics]

Hello,


Lets imagine that column A has:


10

110

1110

9

18


I would like column B to have some kind of ranking related to column A so that the result would be:


10 4

110 2

1110 1

9 5

18 3


How can I do that for a large list?

 

[carics]

I found my own solution. I was not googling it right: RANK function works perfectly!

 

[NARAYANK991]

Hi ,


Check out the RANK function. The syntax is =RANK(number,data range,0) ; the 0 can be omitted unless you want a ranking in ascending order , in which case use a non-zero number instead of 0.


Narayan

 

[carics]

thank you mate