How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel

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… Continue reading How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel

How to work more productively online using new conditional formatting options to highlight dates in Excel

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.
The post How to work more productively online using new conditional formatting options to highlig… Continue reading How to work more productively online using new conditional formatting options to highlight dates in Excel