How-To Geek on MSN

Everything You Need to Know About Array Constants in Excel

Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...
TechRepublic

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

How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel Your email has been sent Most Microsoft Excel functions are autonomous—one result value for each function or formula.