Excel Forum
Similar Content
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Delete Entire Rows Based on Predefined Criteria (Text)
Macro: This macro will allow you to specify certain criteria and then to delete rows based up...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can...

Excel Magic Trick 445: Complicated Criteria for MODE calculation LOOKUP

Advanced Array Formula. See how to calculate the MODE and use the MODE to lookup a value using the functions LOOKUP, CHOOSE, MODE, MIN and IF.

Got a Question? Ask it Here in the Forum.