Showing posts with label Rank. Show all posts
Showing posts with label Rank. Show all posts

Friday, December 20, 2024

How to get Ranking of the Students in Excel using RANK Function


=RANK(number,ref,[order])

To rank in descending order, we will use the formula =RANK(B2,($C$5:$C$10),0)

If we want unique ranks, we can use the formula:

=RANK(C5,$C$5:C$10,0)+COUNTIF($C$5:C5,C5)-1

For ascending order, the formula would be:

=RANK.EQ(C5,$C$5:C$10,1)+COUNTIF($C$5:C5,C5)-1

Command to install direct admin on ubuntu 22.04

 sudo apt update sudo apt upgrade sudo apt install wget gcc g++ make flex bison openssl libssl-dev cd /usr/local/src wget https://www.direct...