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.