Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December. The Weekday function ...

There are many ways to sort data in Microsoft Excel, and one of the simplest and most convenient is the SORTBY function. It lets you dynamically sort your data by more than one array while preserving ...

Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what your workbook already contains, but it analyzes the data ...

Please note: This item is from our archives and was published in 2005. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I know 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.