Excel’s BYCOL() and BYROW() functions appraise information across columns and rows, returning an array end result set allowing you to bypass a whole lot of function.
The post How to use BYCOL() and BYROW() to appraise facts throughout columns and rows in Excel appeared to start with on TechRepublic.
