ranking formula start from negative number

Question

How to make a ranking formula but starting from negative numbers and preventing double rankings

This is the link.

I tried the formula but it didn't work as I expected =RANK(A2,$A$2:$A)

So sorry, i delete the tag
– Davidson
Commented Sep 29 at 11:59 — Davidson, Commented Sep 29 at 11:59

rockinfreakshow · Accepted Answer · 2024-09-28 07:16:02Z

2

You may try:

=map(A2:A,lambda(Σ,if(Σ="",,rank(Σ,A:A,1)+let(Λ,countif(A2:Σ,Σ),if(Λ>1,Λ-1,)))))

answered Sep 28 at 7:16

rockinfreakshow

29.1k4 gold badges16 silver badges28 bronze badges

Thanks - I'll delete my comment.
– nkalvi
Commented Sep 29 at 11:17
Can you explain what for sigma and lambda symbol in that formula?
– Davidson
Commented Sep 29 at 12:16
1

I used those symbols as per my convenience. You can totally change them as per how you want to name the identifier. Look into LAMBDA formula documentation for a bit more clarity
– rockinfreakshow
Commented Sep 29 at 12:22
Thank you for your explanation 🙏
– Davidson
Commented Sep 29 at 12:26

Add a comment |

1 Answer 1