Excel Forum
Similar Content
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
Excel VBA Course
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



Excel Magic Trick #131: Ranking w MIN IF OFFSET


See the functions COUNTIF, MIN, IF, OFFSET, VLOOKUP functions formula used in a table to complete a complex ranking. Other Excel concepts: 1) See how to change the calculation at every change in a sorted list, and 2) How to use OFFSET to change the range for your function.





Got a Question? Ask it Here in the Forum.