Excel Forum



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.