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.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

As soon as Excel recognizes a pattern, a floating window appears that offers to fill the remaining cells in that column with a formula.

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 ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Select a range of cells in the column rather than the column header if you only want to fill a portion of the column with zeros. If your data already contains a column of zeros, skip this step.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.