I want to generate Rank similar function works like DENSE_RANK()
in database product (such as SQL Server
).
Here is sample data :
Col1
1
2
3
4
4
So, i want to be generate following sequence.
Col1 sequence
1 4
2 3
3 2
4 1
4 1
As of now i have use rank()
function. But, it doesn't work as i expect.
=RANK(A1,A1:A5, 0)