Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Mr Excel & excelisfun Trick 91: Rank Scores, But If Tie Award Highest Rank To The Largest Weight

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,360
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 17, 2011

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.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (6)

Sign In or Sign Up now to post a comment!
  • @yhcheung8 , you are welcome!

  • Thank You:D

  • @krn14242 , that's funny!

  • Pays to be heavy I guess after all. 

  • @shiryu008 , cool1 I am glad that you liked it!

  • beautifull as usual guys.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more