Hello friends, hopefully you will be enjoying your life with good health and spirit.MS Excel is an important tool which make your work easier and efficient. Proficient use of excel may save your precious time. In today's post I would like to share how to rank any table in MS excel.
Rank function is useful when you are evaluating a big data file where you have to sort out data ranking either ascending or descending order. e.g. If you are evaluating a big cost evaluation and you have to find the lowest bidder or you are preparing result. This function can be used easily all such works.
Learn By Example
We have a data of companies which took part in the bidding option. We want to select the lowest bid from the cost offered by various companies. We can use Rank function to calculate the rank of each company where they stand.
Enter the data in MS excel sheet.
You can find rank option in formula tab. Just click at formula, more function tab, compatibility and you will find rank function in the below tab. You can also use "=rank" in the formula bar directly.
Rank function need three value to perform. First is the cell you want to check the rank, second one includes the list where you want to rank and third value includes the order you want to perform.
To select order there are two option "0" & "1" Use zero if you want Descending order and 1 if you want ascending order.
Apply the formula =rank($C2,$C$2:$C$20,1)
The first value is showing the cell number you want to determine. i.e $C2
The second value is the list of cell from where you want to check i.e $C$2:$C$20
The third value is the order. I want ascending order so i select 1.
Remember, use absolute cell to avoid any mistake. Any cell can be absolute by using "$". If you want to make column and rows absolute use $ sign before each column and rows. e.g "$C$2" This is absoluate cell. If you want to fix column use $C2. You can change the sign by using F4 command.
Apply the formula to the first row.
Now drag it to the remaining part of the table.
Excel will perform quick calculation for you. I hope you will like my today's post. Don't hesitate to comment if you want to ask something. Wish you all a very happy, healthy and prosperous life ahead. Have a nice time.
