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.
The post How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel appeared first on TechRepublic.