Excel Forum

Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT

See how to rank values based on one criteria using the SUMPRODUCT function. Another amazing formulas from the Mr Excel Message Board.
Rank small number is best.
Rank big number is best.
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.