Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See Mr Excel and excelisfun use two methods to rank scores with the heights Weight:
1. See how to use RANK or RANK.EQ and SUMPRODUCT functions and an array to calculate rank when there are ties.
2. See how to use the RANK function and COUNTIF and the Sort Feature.
@yhcheung8 , you are welcome!
ExcelIsFun 1 week ago
Thank You:D
yhcheung8 1 week ago
@krn14242 , that's funny!
ExcelIsFun 3 months ago
Pays to be heavy I guess after all.
krn14242 3 months ago
@shiryu008 , cool1 I am glad that you liked it!
ExcelIsFun 3 months ago
beautifull as usual guys.
shiryu008 3 months ago