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

ExcelIsFun

  • Currently 0.00/5
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 0.0 out of 0 votes
Comments (0)

Refresh page if video doesn't load!!! Download Video Mr Excel&excelisfun Trick 91: Rank Scores, But If Tie Award Highest Rank To The Largest Weight

You need to have the Flash Player installed and a browser with JavaScript support.


Lights off
Sorry, your favorites list is FULL.

Link to this video

Description

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.

Tags



Comments

Be the first to comment

Sign in or sign up to post comments.
Artist: ExcelIsFun
Video title: Mr Excel&excelisfun Trick 91: Rank Scores, But If Tie Award Highest Rank To The Largest Weight
Category: Education
Views: 1543
Submitted by: admin