If you want to find number 1,2,3,... then Rank could help you but it comes with some tricks if you don't understand the concept. Please refer to the video for more information. RANK Formula
=RANK(Number,Ref,[order])
=Average(start_cell:end_cell)
◾ Number: Required, total or average value to find rank=Average(start_cell:end_cell)
◾ Ref: Required,set of range or cells to compare with number.
◾ [order]: optional
Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel
0 comments: