Create Account

Free Excel Macros
Keyboard Shortcuts
Contact

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Tutorials

Featured Tutorial

Dynamically Update Drop-Dowm Menus in Excel

Featured Macro

Delete Empty Rows in Excel

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.