Figure E Use Excel’s BYROW () to evaluate by rows. As with Excel’s BYCOL (), you could do this with several MAX () functions, but that would require 11 functions and would return 11 result values.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.