How to use BYCOL() and BYROW() to evaluate data across columns and rows in ... returns an array. The real power here is that you can substitute MAX() with just about any Excel function.