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 .

It can be tedious to manually edit each LARGE or SMALL function manually with the proper value for the k argument if you want to create a list of the top or bottom 10 values. To save time, use the ROW ...