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.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

In Microsoft Excel, VLOOKUP (vertical lookup) is a search function that you can use to find any data inside a particular column of the table by looking at the first column's entries and returning ...

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...

How to Use Column Headings in Excel. For many small business owners, Microsoft Excel 2010 is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare ...

How to Sum a Column of Zeros in Excel. You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of ...