Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

To find the minimum or maximum value in a column, add MIN() or MAX(), respectively, to the bottom of the data range and use this formula rule in step 5 =B2=B$5 .